98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Creating a query in MS Access
Creating a query in MS Access
Resolved · Low Priority · Version 2003
Thu 4 Feb 2010, 13:27Delegate Tim said...
Tim has attended:
Access Introduction course
Creating a query in MS Access
Hi, having had the Introduction to MS Access 2003 course on 2 Feb, I have now received the post-course reference manual (all 105 pages of it!) but there is no mention of Queries in it, and this is one of our principal requirements.
We have three databases of names (which don't need a relationship), from which we need to extract queries of who was in the UK during any given two-month period. Anthony Malone said that the way we were doing this was inefficient, not to mention wrong, and that we could set up a query that would ask for start and end dates for the period required each time it was clicked on before producing a table of results. I have created a query, taking fields from one of the three databases in question, but can't make the above happen. I seem to remember something about putting <[Enter] and >[Enter] in the two date columns but this isn't working.
Thu 4 Feb 2010, 13:59Trainer Anthony said...
RE: Creating a query in MS Access
Hi Tim, thanks for your query and sorry to hear about the lack of information about queries, we will address that.
In your queries, your date requirements were "hard wired' in. In the training session we replaced those hard wired dates in the criteria boxes with:
Between [Enter Start Date] And [Enter End Date]
This will trigger two input boxes with the text in square brackets on each one and the dates entered will be fed back into the query. In this way, you can enter your date requirements far more easily that editing the query itself each time
I hope this helps. Let me know how you get on.
Anthony
Thu 4 Feb 2010, 14:34Delegate Tim said...
RE: Creating a query in MS Access
Hi Anthony,
Done! I had to add a < and a > before the square brackets in order to capture the two-month period, so I was on the right lines - it was just a matter of knowing what to put in the brackets. Anyway, thanks for your help (and it won't be the last time, I guarantee!) - it works a treat!
Can you check-out the reference manual please and forward any stuff about queries that ends up going in.
Cheers,
Tim
Thu 4 Feb 2010, 14:00Trainer Stephen said...
RE: Creating a query in MS Access
hi Tim
Thanks for your question
The type of query you are referring to is called a parameter query. In the example give, you would use the following syntax
Between [Enter First date] and [Enter second date]
Hope this helps
Regards
Stephen
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Hide Access TablesOne method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys. |
