keyword query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Natalie - 12 Sep 2006 21:50 GMT

I'm creating an inventory database with a field named "item description". I
want to create a query that can search for keywords in this field and output
a result. For example, this field will contain data like "Kingston 1GB
JumpDrive". I would like to be able to search "Kingston" and have this record
come up. How would I do this? Is it even possible?

Reply to this Message

KARL DEWEY - 12 Sep 2006 22:24 GMT

Use this as criteria --
Like "*" & [Enter your search keyword] & "*"

> I'm creating an inventory database with a field named "item description". I
> want to create a query that can search for keywords in this field and output
> a result. For example, this field will contain data like "Kingston 1GB
> JumpDrive". I would like to be able to search "Kingston" and have this record
> come up. How would I do this? Is it even possible?

Reply to this Message

Natalie - 12 Sep 2006 22:37 GMT

Thanks, worked perfectly. :)

> Use this as criteria --
> Like "*" & [Enter your search keyword] & "*"
[quoted text clipped - 4 lines]
> > JumpDrive". I would like to be able to search "Kingston" and have this record
> > come up. How would I do this? Is it even possible?

Reply to this Message