J Jerry8989 Registered User. Local time Today, 08:01 Joined Mar 16, 2006 Messages 64 Mar 1, 2007 #1 I would like to know if anyone knows if I can create a query that will give me a count of the number of queries within my access DB? Thank You
I would like to know if anyone knows if I can create a query that will give me a count of the number of queries within my access DB? Thank You
pbaldy Wino Moderator Staff member Local time Today, 05:01 Joined Aug 30, 2003 Messages 36,157 Mar 1, 2007 #2 Try SELECT Count(*) AS HowMany FROM MSysObjects WHERE Type=5 AND Left([Name],1)<>"~"
J Jerry8989 Registered User. Local time Today, 08:01 Joined Mar 16, 2006 Messages 64 Mar 1, 2007 #3 Thanks Thanks that did it
