Query Question

[TryAgainToo]

This should be easy, but I'm drawing a blank. I have a Paradox interactive Query that counts the number of records matching a particular criteria (in this case a month/year field) that contain a blank in one of the fields. I would also like the query to produce a count of all the records that match the criteria (regardless of if one field is blank or not). I can run these as separate queries, but when I try to combine them I get an error about asking 2 unrelated questions. Ideally I would like the answer table to look like this (assuming the criteria is ../97 (all months in 1997)
Volume TotalBlanks Total Records
1/97 15 76
2/97 24 58
3/97 3 83
etc.
So, does anyone know how to make this work? I don't think it should be difficult, I must be missing the obvious!

Lynn

 

[hcts]

One way would be to put a CALC . AS Total Records in the first query that calculates the number of blank records, then run the second query for the total records, and run a third query that is a changeto query to update the Total Records in the first answer table with the answer in the second. You would have to link the two by volume.