Search Function

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

Guest

I have made a database for us to use at a helpdesk. This database is for a
skill set of people that we have working for an account.

I have it all up and running ok, but i would like to add a new function to
the database.

I have made up a field called Notes. In this field is all the areas that
they are good in that is not related to the company specific work. In this
field would contain entries like, "Routing Master, VBA, HTML, and XML" just
to name a few. Now not all people in this database will have something like
this in that field, but it is in that nature....

When i tried to run a query for say just looking for HTML, it comes back as
no one having this skill under my notes field.

I dont wanna have to look at everyone's contact page to see what all their
notes are if i am just searching for one thing. The only way i have been able
to produce a positive result is if i only have "HTML" in that field. but if i
add something else to it... it just makes the search void/null.

Is there something i can do to make a field searchable for anything that is
listed in it?

Would i need to impliment some VBA into the database for it to work right?

Thank you for your time and look forward to a response.

Douglas
 
A generic query that will return records with the text string HTML anywhere
in the Notes field:

SELECT *
FROM TableName
WHERE NotesField Like "*HTML*";
 
A better solution might be to create a related table with one record per
person per skill. This would be much easier to query.

However, if you want to continue storing multiple values in a single field,
you can use a criteria under the "notes" field:

Like "*" & [Your expression here] & "*"
 
Thanx Duane, This was much better to understand. Appreciate the both of you
that responded.

Now its off to the world of VB so i can implement a popup box "Search" so i
can search for whatnot when users are in the switchboard....

Thanx once again

Duane Hookom said:
A better solution might be to create a related table with one record per
person per skill. This would be much easier to query.

However, if you want to continue storing multiple values in a single field,
you can use a criteria under the "notes" field:

Like "*" & [Your expression here] & "*"

--
Duane Hookom
Microsoft Access MVP


Douglas @ Helpdesk said:
I have made a database for us to use at a helpdesk. This database is for a
skill set of people that we have working for an account.

I have it all up and running ok, but i would like to add a new function to
the database.

I have made up a field called Notes. In this field is all the areas that
they are good in that is not related to the company specific work. In this
field would contain entries like, "Routing Master, VBA, HTML, and XML" just
to name a few. Now not all people in this database will have something like
this in that field, but it is in that nature....

When i tried to run a query for say just looking for HTML, it comes back as
no one having this skill under my notes field.

I dont wanna have to look at everyone's contact page to see what all their
notes are if i am just searching for one thing. The only way i have been able
to produce a positive result is if i only have "HTML" in that field. but if i
add something else to it... it just makes the search void/null.

Is there something i can do to make a field searchable for anything that is
listed in it?

Would i need to impliment some VBA into the database for it to work right?

Thank you for your time and look forward to a response.

Douglas
Click to expand...
Click to expand...
 
Back
Top