Can this be done?

[Trigg51]

Is it possible to get a query to look at several fields.
Problem is I have personal details table. Each person can have upto 5 mobile numbers.Each number has it's own field. I want a query to ask me for a number and it will find the record with this number and display all the fields from this record.

 

[Candyman_mm]

You need to run a [enter contact] query. For this, you need to go to design view and select the field of records yu ned to view. In the field which has the mobile number heading you need to go to criteria and type. like[enter number]"*"

 

[Trigg51]

Tried it in one field but got an invalid syntax error. The error was highlighting the "*" part of the statement.
The mobile numbers actually have a field each, called 'Mobile Number 1' and so on.

 

[Candyman_mm]

Is it possible for you to send me a layout of the database...just the first three rows.(crearymm@netscape.net)

 

[Trigg51]

You got mail.

 

[Candyman_mm]

Triggs, I will get back to you in a few....kinda busy doing some domestics.

 

[Trigg51]

Thanks for the help but I seem to have solved it with an 'Instr' statement. Thanks again for your time

Trigg