Access

Resolved · Low Priority · Version 2003

Tue 10 Jun 2008, 16:34 Delegate Simon said...

Simon has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course

Access

If you have a parameter in a query but do not wish to enter a value, what should you do? Should you leave the box blank and click OK or just hit enter?

Thu 12 Jun 2008, 12:56 Trainer Carlos said...

RE: Access

Hi Simon

When using parameter queries you always need to enter a value otherwise you get blank lists or errors.

To onercome this you should create your parameter using the wildcard. For example:

=[Please enter a Code] & "*"

This will allow you to leave the box blank and have the system return all values.

It also allows you to make a partial entry and have the computer return all values beginning with that

Hope this helps

Carlos

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips