Dec 8 2008, 02:26 PM
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.
Dec 8 2008, 02:38 PM
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.
Dec 8 2008, 02:39 PM
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.
Dec 8 2008, 02:48 PM
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.
Dec 8 2008, 03:07 PM
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.
Dec 9 2008, 07:44 AM
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!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here