I am tinkering with Queries, trying to get one that will work the way I need, but now I have about 12 queries all with similar names. I can't find any way to delete existing queries. Googling and searching the help file does nothing.

Any recommendations?

Welcome to UA Forums!

I have not used 2007 in a while, but I think you can select the query in the database window and hit the delete key on your keyboard.

HTH

-Trapper

With the database window open, you should just be able to select the query you don't want and hit the delete key on your keyboard.

HTH

Wow... i just realized it was under "unassigned objects" and I had them hidden. That's why I couldn't find it! Thanks!

Now a quick question way off from my original. I have a list of "Dates Received" and on my Form I have 2 Text Boxes. [DateStart] and [DateEnd] and a button [Go]

Can I somehow create a filter or query to simply show me all of the entries that fall between the dates in the text boxes?

I am really really new to Access so I have started with the Tasks template and it is now HEAVILY modified


Oh and Thanks for the kind welcome!!

Edited by: Damien on Mon Dec 8 14:48:47 EST 2008.

In the design grid of the query, try this in the criteria:

Between Forms!FormName.DateStart And Forms!FormName.DateEnd

substituting the name of your form of course.

I can't believe how that just... WORKED

Hah thanks! I'm going to look like a genius to my colleagues now!

Now I have to work on creating a pie chart showing the number of reports from each reporting company for that time period. Then i think I'm done.

I appreciate the help and if I can't figure out the pie chart thing I'll post another question!