Running queries

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

Guest

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
 
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/
 
Back
Top