Parameter Query for a whole table....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top