Finding a record where 4 criteria must match

imwalrus38

Registered User.
Local time
Yesterday, 22:19
Joined
May 27, 2005
Messages
31
How do I set up a search on my form where 4 fields must match exactly to return the correct record? I must match - persons name, description, type and date.

Thanks
J
 
Hello J,

Is the search always going to be based off of all four fields or is there going to be times that it's searching for a combination of fields. ie. the persons name and date and not the other two fields?

If it's all four fields, always, then the approach would be simplier, if it's a combination of, then it would have to be set up more dynamically.

Shane
 
It would always be all four fields.
 
Hey J,

I should have thought to ask this the first time. How are you going to perform your search? What are you going to use to set up your criteria to perform a search?

Sorry,
Shane
 
I'm guessing the criteria will need to be all 4 fields must match exactly. Then return that record. I need to be able to find the correct record to add additional information to other fields. I will have all the info for these 4 fields when the record is created but won't have all the other info at that time.
 
Hey J,

Sorry for not getting back to ya sooner. I've been MIA for a day or so. Do you still need help with this or have you found a solution?

If you haven't, I can see one of your fields, to use for criteria, is a date field. Are the other 3 text fields?

Are you going to use SQL on the forms Record Source to find the matching records?

Shane
 
Yep I still need help. The other 3 fields are al text field. I pretty new at this so I'm sure about SQL. I was trying to do this with a macro. Thanks for your help.

J
 

Users who are viewing this thread

Back
Top Bottom