Create a query on all queries in my database

[Trisha]

Hi there,

I am hoping to do a report all my queries in my Database.
I have managed to use some sql code to list the queries which is the following:
SELECT MSYSOBJECTS.Name
FROM MSYSOBJECTS
WHERE (((MSYSOBJECTS.Type)=5) AND ((Left([NAME],1))<>"~"));

But i cant seem to get any further i would also like to include the creation date, the description if any, the tables associated with each query,
as i know i have a good few queries which maybe duplicates i just want to clean it up
Any help greatly appreciated

 

[jdraw]

Try

SELECT MSYSOBJECTS.name, MSYSOBJECTS.DateCreate, MSYSOBJECTS.DateUpdate
from MSYSOBJECTS
WHERE (((MSYSOBJECTS.Type)=5) AND ((Left([NAME],1))<>"~"));

Tables are not part of the query record in the MSYSOBJECTS table.

 

[Trisha]

Thanks jdraw for the fast reply
and i see know where the date create and date modified can be put into the query. Is it possible to also add the description (if any) associated with each query to the outcome of the query
and is there any other way that i can get a list of queries with the associated tables or is this even possible, or even the list of queries with the table headings it is using. just trying to find a way to get this information rather than having to go through each of the queries, of which i have alot off, manually.