How to define a field to aid searching

  • Thread starter Thread starter Bam Bam
  • Start date Start date
B

Bam Bam

Hi all,



I've been asked to make an access database for some friends with a rare CD/
record shop. Eventually we may put it online using ASP pages to handle
record retrieval and

Searching. I would like to design it to be easily searched from the start
and am not sure which way to go with the 'Artist Name' field/s in the Artist
table.



e.g Field 1 "David", Field 2 "Bowie"



or Field 1 "Bowie", Field 2 "David"



or Field 1 "David Bowie"



or Field 1 "Bowie, David"



or something else.



Can anyone direct me towards any examples of how to define this field?
 
u could do it any of the ways that u have suggested, but a
simple method would be to just enter his name as David
Bowie in one field name.Then for ur query on searching
artists name, u can search for either david or bowie
independently, ie u dont have to enter the full name David
Bowie, so its pretty efficient. u just construct the query
using the following code in ur where clause:

WHERE ((([Music)].[Artist)]) Like '*' & [Enter Artist
Name] & '*'));

in the above music and artist are just what im calling
them, whatever name u have used for the fields include
them here
 
Thanks Deviner,

I thought that might be the simplest way but I guess I thought it was too
simple to
be real. It's just that I have seen an example where each individual word
that makes up an
Artists name is held in a different field. I thought to facilitate better
searching but now can't
see a reason why if using 'like' will the trick.

Thanks again
 
Bam Bam said:
Thanks Deviner,

I thought that might be the simplest way but I guess I thought it was too
simple to
be real. It's just that I have seen an example where each individual word
that makes up an
Artists name is held in a different field. I thought to facilitate better
searching but now can't
see a reason why if using 'like' will the trick.
Click to expand...

It is possible to do this with Access but takes a bit of work if the name is
in one field.

However combo boxes make this a bit easier if the names are in separate
fields.

You'll have to decide what how to handle "The Famous Group" Do you include
the "The" and if so where. This makes a single field with the individual
words indexed more attractive.

You might also consider soundex for people who are not sure of the
spelling.
 
Back
Top