Count Records in Two Queries?

[kestefon]

I have two queries, let's called them Query1 and Query2. I'd like to create a third query that looks like this:

File          RecordCount    Date
Query1.txt      ###      (Current Date)
Query2.txt      ###      (Current Date)

I know I can use concatenation and a date function for the first and third fields, so my main question is the proper syntax in order to get this layout.

Thanks!

[kestefon]

Any ideas? It seems like it should be simple, but I can't get the SQL to work.

[John_G]

Hi -

Try the DCount function.

Dcount("*","table or query name","criteria, if any")

The criteria part can be left out if you just need a count of all the records.

But how are you going to get the table / query names? They have to come from somewhere; you cannot hard-code them in the query. You could do it quite easily by putting the table or query names in another, separate small table.


HTH

John