two separate queries, then aggregate the output using a 3rd query or macro

[Lifeseeker]

Hi,

I'm not sure if this is possible, but certainly worth asking I think..

I would like to make two queries, both a count queries, which will produce two outputs.

Then I envision a third query or a macro of some sort to perform simple calculation such as addition, subtraction or even division on the two outputs.

Can this be done easily in access 2003? Or some kind of VBA should do?

Thank you

 

[plog]

Yes and yes. Create your queries to get the values you want then you can use a DLookup function to retrieve those values and then perform your operation on them. DLookup can be used in VBA, on a form, in a query or on a report.