Forum home » Delegate support and help forum » Microsoft Access Training and help » access-course - Filter

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

access-course - Filter

Resolved · Low Priority · Version Standard

Reply Wed 19 Sep 2007, 16:20Delegate Steve said...

Steve has attended:
Access Introduction course
Access Intermediate course

Filter

how to filter mutilpe criteria on various tables at the same time

For upcoming training course dates see: Pricing & availability

Reply Fri 21 Sep 2007, 15:26Trainer Richard said...

RE: filter

You need to add the tables to the query,link them together and show the fields you want to filter.

Then add the criteria to the fields you want to filter

Access articles

· Discover The Top Ten Changes In Access 2010
· Making Figures Talk For Themselves Thanks To Access
· How To Make One Combo Show Values Determined By Another Combo In Access
· Microsoft Access Tighten your Security Controls
· How To Use Lookups For Data Entry In Microsoft Access

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy