Parameter Query for a whole table....

[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.

 

[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.

 

[Guest]

Steve,

Thanks for trhe quick response. Worked faultlessly!

Thanks,

Anton