Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Access 2007 Query Question!?
How do I write a query that will do a search across (7) fields after the parameter has been entered? Also in what field/s would I enter the parameter?
Example:
I have (7) fields labeled:
Field 1: Traveler 1
Field 2: Traveler 2
Field 3: Traveler 3
Under criteria in field 1 if I enter [Enter Traveler 1] the user would have to enter a Traveler # that was input in that field. I need to have the parameter ask [Enter Traveler] and have it search in all (7) fields.
Thanks!
The information is all in one table.
1 Answer
- Anonymous1 decade agoFavorite Answer
I don't think I understand your question - are all of these fields in the same table, or multiple tables?
It is impossible to offer an answer on this question the way it is worded. If you can explain better - by relating fields and tables, and explaining exactly what you want to happen in those terms, I can try to help.