calculate total records from two queries

[jstarace]

I am working on my first ACCESS project and have run into a bit of jam. I have created a form showing total number records of different queries. I want to put an additional row on my grid that totals the number of records from two different queries which have criteria defined.

I have written the following expression hoping for the best, but the result returned is the total number of records in the table the two queries are based on, which BTW comes back as a negative number.

=Sum((DCount("*","qryPhoto1&quot) And (DCount("*","qryComp1&quot))

Any suggestions would be appreciated.

I just want to display the total number of records from two different queries!

Thanks

 

[Eupher]

Try this:

=DCount("*", "qryPhoto1&quot + DCount("*", "qryComp1&quot

Ken S.