tables - keyword field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Just curious...I would like to have a field for keywords in my data table
that would be searched by a form-based query by the user. This field would
have multiple words. Do I need to separate them with a semicolon or
something?

The search will be open ended, ie) where tblkeyword = "*" & [dataentrybox] &
"*"
 
Do remember, though, if you are storing your keywords - rather than searching
a text field - you will do better to create a second table:

tblKeywords
[Table1].[PrimaryKeyField] [PK] [FK]
Keyword [PK]


Sharkbyte


Rick B said:
No, you would not need to separate them with a semicolon based on your
search.

--
Rick B



polisci grad said:
Just curious...I would like to have a field for keywords in my data table
that would be searched by a form-based query by the user. This field
would
have multiple words. Do I need to separate them with a semicolon or
something?

The search will be open ended, ie) where tblkeyword = "*" & [dataentrybox]
&
"*"
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting on a Keyword 1
keyword table 2
Fastest methods for text searching. 6
keyword 2
keyword search in query using like function 1
Form Troubles 1
keyword 2 2
"like" search function 2

Back
Top