CODEWITHSUNDEEP
ms-accesscountmax
YvetteLee
YvetteLee

Reputation: 1090

Ms Access query wih all tables MAX and COUNT the GUID field

I need to make a form that will show me from all the tables in my database the MAX and the COUNT of the GUID (autonumber field). Is it possible to do it with one query?

Now I am do it with each table having a query. So if my database has 23tables, I have 23queries.

Thank you.

Upvotes: 1

Views: 44

Answers (1)

YvetteLee
YvetteLee

Reputation: 1090

 SELECT 'Table1' as Table, MaxValue, TableCount From Query1 UNION ALL SELECT 'Table2' as Table, MaxValue, TableCount From Query2...

Upvotes: 2

Related Questions