Query with Multiple check box field

[preveo]

I have a query with a multiple entry field. However when I run the results it multiples the records for each multiple input entry for that record.

Any way to display a query which also contains a drop down with the multiple entries so the records aren't duplicated?

[ranman256]

Muli-item lists are horrible for queries. BEST: You must 1st scan your list values into a table. Then the query can just pull the table.

[rpeare]

Are you saying

a. you have a field in your table that is a 'multi value field'
b. you have a query made of a 'main' table and a 'sub' table where there is a one (main table) to many (sub table) relationship and you want to make it show just one line per item on your 'main' table

if it's a. You are better off redesigning your table to follow a more normalized structure, multi value fields on tables are an exceptionally bad idea and are extremely hard to work with.

if it's b. There are ways to concantenate mutliple values into a single field but it involves VBA code. one example is linked below, there are others if you look for 'concantenate multiple rows into single field' or similar seaches.

http://www.databasejournal.com/featu...ith-Access.htm