Report with value list combo - Value List Combo Box in Microsoft Access


	Back to Value List Combo Comments List

Upload Images Link Email

Report with value list combo

David Dunham

2 years ago

I have a table with multiple fields using value list combo's. I run a query including more than 1 field with VLC's but using criteria to limit one of the VLC fields to one value (text). The query runs correctly but when a base a report on the query the report counts all values in the unlimited VLC fields of the query as separate records giving a total of records greater than the query total. Any ideas for a solution?

	Adam Schwanz 2 years ago
Having trouble visualizing the problem, can you upload some images of all the relevant information? Image Uploads

	David Dunham OP 2 years ago

	David Dunham OP 2 years ago

	David Dunham OP 2 years ago
Adam - I uploaded a snip from query & report for the same records. Thanks for your help.

	Adam Schwanz 2 years ago
I think the only time Ive seen something like this it was something weird to do with Null values and "" (Empty String) not reading the same. Can you share the design view of the query and what concatenation is putting Cul de Sac, Laguna togethor?

	David Dunham OP 2 years ago

	David Dunham OP 2 years ago

	David Dunham OP 2 years ago
Adam - Couple of snips with Query & Table design.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Value List Combo.