Parameter Query for a whole table....

A

Anton

Hi,

Is it possible to have a parameter query that looks through all the fields in a table? I want to use a LIKE criteria within a PARAMETER query that can search the whole table, instead of just one field.

Is this possible?

Thanks,

Anton.
 
S

Steve Schapel

Anton,

I think if you put exactly the same parameter prompt in the criteria of
more than one field in a query, the prompt will only pop up once, and
the criteria will be applied to all fields where the criteria was entered.
 
Top