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 » Query criteria
Query criteria
Resolved · Low Priority · Version Standard
Mon 25 Feb 2008, 15:55Delegate Emma said...
Emma has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Query criteria
in the query criteria box, can you do more formulae than just AND or IF?
Thu 6 Mar 2008, 15:48Trainer Rajeev said...
RE: Query design view calculating fields
Dear Emma
Thank you for attending the Access Course. I hope the course was beneficial to you!
Yes there are other calculations that you can perform other then simple AND OR queries!!
I am not sure if you have attended the Access Intermediate course or not you will or would have learnt that you can create a new field in a Query Grid box which can be used for calculating various fields.
This is how you would normally perform calculations based on other fields in Query!
Please refer to the Access file that I have uploaded with this post.
You
Attached files...
Query caluclations.mdb
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:Prefixed AutonumberingWhen using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter. |
