Within my table I have about 20 fields.
I want to do a keyword search that checks through all the fields. I have tried to do this in design view, copying =[enter keyword] into a separate row for each field. Access doesn't seem to like this - maybe because i have too many fields?
Is there a way around this?
TIA
Dusp
I want to do a keyword search that checks through all the fields. I have tried to do this in design view, copying =[enter keyword] into a separate row for each field. Access doesn't seem to like this - maybe because i have too many fields?
Is there a way around this?
TIA
Dusp