Running queries

L

Lucy

I want to run my query via a form on which I have created a drop down list.
Therefore, I'll have to seperate all of the keywords into seperate entries on
the list. E.G:

Data
Apple, ball, cat
dog, elephant
football,
golfball

Drop down list:
Apple
Ball
Cat
Dog
Elephant
....

How can I get the drop down list to show fields with more than one entry as
seperate entries?

Thanks
 
J

Jeff Boyce

Lucy

?You have fields that contain more than one value? That would violate step
1 of normalizing your data structure -- one fact, one field.

Since queries are based on data in tables, it would help to see your
underlying data...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


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

Microsoft Registered Partner
https://partner.microsoft.com/
 
Top