on 10-19-2015 6:32 AM
Hi there
I am trying to write a query that will display all of the BP's with more than 1 property ticked. I'm not too sure which table that data is stored in or how it's linked to OCRD - the OCQG table seems to just be a table of group names.
Any suggestions?
HERE YOU GO.
Just add all QryGroup4 until QryGroup64.
SELECT * FROM OCRD
WHERE ASCII (QryGroup1) + ASCII (QryGroup2) + ASCII (QryGroup3) .......
+ ASCII (QryGroup64) > 78 * 63 + 89 * 1
Frank
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Josh,
each Property has its own field. if activated value is 'Y'
empty = 'N'
first Idea is to create a query:
Select CardCode, Cardname, Qrygroup1, Qrygroup2,...
and after that use Export to Excel an make filters... Of course, it is not very smart.
Hope that helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.