Help with Query

  • Thread starter Thread starter SX
  • Start date Start date
S

SX

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


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