multiple field search on a form

[robbin]

I have 13 fields of procedure codes for a single surgery. I have a form that "look for all patients with this procedure code" and I enter the number I am looking for. How can I merge all 13 fields into a single field?

 

[shacket]

The correct way to structure your data would be to have a separate table linking your procedure codes to each procedure (i.e. surgery). You may want to consider redoing your tables to this structure to avoid problems in the future.

If you want to get around it, you could create a static table with the 13 codes or put it in your VBA statement. This would only work for this one procedure and be very time-intensive to do for each surgery (depending on how many you have).

Let me know what you decide.

 

[robbin]

I don't think I told you my problem clearly.
one line of data has up to 13 different numbers. I can either leave them in 13 different data boxes, or merge them into a single one. Either is possible. But I want the query to find a single number, and then print the corresponding patient name. So if I am looking for number "20" and the data has "1 or 19 or 80 or 20" the query picks out this case with 20 in the series.

 

[robbin]

I figured out how to put in 8 of the 13 numbers by simply using the horizontal lines in the query under "or"
but how can I make more horizontal lines?

 

[shacket]

Insert > Rows

 

[robbin]

thank you
so simple