I'm new and need advice

  • Thread starter Thread starter JennyM
  • Start date Start date
J

JennyM

I am a new user and have build a database full of
resources (with hyperlinks) to files. I have two
different fields with sort of like keywords listed. My
question is how to I go about creating a form that will
allow me to search by keyword in BOTH of these fields?
 
Jenny

What's your underlying business need for having two separate fields -- can
the keywords be contained in a single field? That would sure make your
search easier...
 
I am working with a database that has thousands of entries
and whoever created the database has created it that way.
 
Consider creating a UNION query (see Access HELP) that returns all of FieldA
and all of FieldB. You'd use this as your starting point. If you include
the key field, you'll be able to point back to the rows in which you find
your search value. The SQL would look something like (actual syntax may
vary):

SELECT YourID, FieldA FROM tblYourTable
UNION

SELECT YourID, FieldB FROM tblYourTable;
 
Back
Top