Help with Query

I have a set of data.

In the field there are datas such as

Diet, Health
Diet, Non-Fiction
Romance, Health
Non-Fiction, Diet
Romance, Diet

I wish to make a query that only shows Diet.

How do I do it? I tried typing just Diet in the query but it shows nothing
when I run it, Thanks.

use the criteria

Like "*diet*"

Evi
"SX" wrote in message
...
I have a set of data.

In the field there are datas such as

Diet, Health
Diet, Non-Fiction
Romance, Health
Non-Fiction, Diet
Romance, Diet

I wish to make a query that only shows Diet.

How do I do it? I tried typing just Diet in the query but it shows nothing
when I run it, Thanks.

While Evi has provided a way to locate the rows with "Diet" somewhere in the
field, you have a potentially long-term problem to consider.

A common precept in good database design is "one fact, one field". Your
field, however, appears to hold more than one fact (e.g., "Diet"; "Health").

Have you considered normalizing your data? Access is designed to work with
normalized data.

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

"SX" wrote in message
...
I have a set of data.

In the field there are datas such as

Diet, Health
Diet, Non-Fiction
Romance, Health
Non-Fiction, Diet
Romance, Diet

I wish to make a query that only shows Diet.

How do I do it? I tried typing just Diet in the query but it shows nothing
when I run it, Thanks.