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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query problem 2
Nested Queries Help 1
MS Access Query - Selecting Certain Entries In A Field 1
Pasting cell contents into a macro 1
Get a list of all items in a column? 1
how do i find out what is uncommon in column list A1: A10 and B1:. 1
Quering a drop down column from a table 2
Total appointments per agent 2

Back
Top