Difference between Arrays

[specialist]

Greetings-

I am trying to calculate a difference between arrays which have been defined (and work!).

I have one array which counts the total:
qryPri = "SELECT Count (Entry') as prnRecs FROM tblInfo WHERE... "

Then, I have about 10 other queries which count specifics in the total, such as :

Set qryGroup1 = db.Execute(qryPri & " WHERE Sort = ('S')...

So, my question is how would I format a query to subtract the "qryGroup1" from the query which counts all records?

Keep in mind I have about 13 other queries which need to be subtracted as well from the main query:

(Main - Group1 - Group2 - Group3 etc etc)

I am against a wall on this, any advice would be wonderful.

many thanks,

Mike

 

[Tarwn]

Do you need to be able to output along each step of the way or do you just need the final answer after all of the subtractions?

If you just need the final answer I'm thining you could probably embed all of your logic into one SQL statement, something along the lines of:
"SELECT Count('Entry') as prnRecs FROM tblInfo WHERE (Sort <> 'S')..."
basically tell it to only count where the attributes from all your queries are not true.

Also, I don't see how your getting back multiple values from your selects unless you have some sort of Group By field. If your only getting back single record answers then it should be fairly easy to drop each one in a variable and just deal with the one number.

More info would be helpful,
-T

 

[specialist]

Tarwin-

Thank you for your reply.

I worked around it and created a function which subtracts all of the groups (group 1, group 2, etc.) from the sum.

Works like a charm!!!

Thank you for the reaply and have a great holiday!

Mike