microsoft+access+course - Access - criteria in a query

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

Resolved · Low Priority · Version Standard

Access - criteria in a query

Tina has attended:
Access Introduction course

by - delegate Tina [2 posts] (2007 Aug 6 Mon, 10:42) Reply

How do you filter in the criteria so that only records ending in say 1 are pulled back

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	7	book now	£345	£399
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: Access - criteria in a query

by - trainer Richard platinum contributer [813 posts] (2007 Aug 7 Tue, 10:35) Reply

Try

Like "*1"

in the criteria field of the query

· How Reorganising Your Data Can Take Your Business to the Next Level
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Convert a Paper Trail to a DBMS
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· When Is Microsoft Access Not The Best Choice For Your Business?

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips