ms-access-course - Criteria In Queries

The UK's most regular instructor-led training courses.
Training information: ms-access-course · Access course microsoft training · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Criteria In Queries

tina has attended:
Access Introduction course

by - delegate tina [1 post] (2007 Jan 30 Tue, 16:23) Reply

How do I set changeable criteria in queries?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Criteria In Queries

by - trainer Richard platinum contributer [818 posts] (2007 Jan 30 Tue, 16:45) Reply

If you use square brackets in the criteria field

eg. [criteria here]

then access will prompt you to enter the value when the query is run.

· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· Learn about Subqueries in Access Courses
· Microsoft Access, an Efficient Database Tool
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses

Access tip:

Remove spaces in a table

If you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks

View all Access hints and tips