Forum home » Delegate support and help forum » Microsoft Access Training and help » Access query
|
|
|
The UK's most regular 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 query
Resolved · Medium Priority · Version 2007
Reply Wed 22 Oct 2008, 15:48Delegate David said...
David has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access query
how do you enter criteria that relates on field to another (in the same or different table)?
eg you have a table called 'product' with the following fields:
-prod id (primary key)
-prod name
-qty available
-minimum order
and you want to run a query that shows all records where quantity available > minimum order
Thanks
For upcoming training course dates see: Pricing & availability
Reply Wed 29 Oct 2008, 21:27Delegate Mark said...
RE: access query
Hi David,
create the query with the fields you wish to show as usual. Then to a blank grid column at the end type into where the field name normally goes Expr1:([qty available]-[minimum order]) so that you are subtracting the one from the other. Then in the criterea cell beneath it put simply >0 Also, uncheck the show box. Press run and it should work. Thinking about what you may be trying to achieve if you actually need greater or equal the the criteria will be >=0
This should work.
Regards, Mark (delegate)
Reply Tue 11 Nov 2008, 20:26Delegate David said...
RE: access query
hi mark,
yep that's brilliant, thanks very much!
RE: access query
Dear David
Thank you for attending Access Intermediate!! I hope you enjoyed the course and benefited from it.
Download all the fields that you require in Query desgin view.
In the Criteria box for Qty_Available please enter the following criteria:
>[Min_Order]
You'll get your result.
Please remeber that any field name gets put inside the square brackets!!
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
|