I need to create a report that only shows 1 entry per value

[rpresco]

My queries have multiple entries with same value by design. I need to know
how to create a report that only shows the first entry of each value. Can
someone help?

 

[Duane Hookom]

Have you considered using the Hide Duplicates property of your text boxes?
You might also be able to use grouping and place the repeating values in
your headers.

 

[Larry Linson]

You might be able to do what you want with a Totals Query using a Group By
clause specifying the value for which you only want one entry. In that
Totals Query, for other fields of interest you can specify "First", if that
is what you want.

Larry

My queries have multiple entries with same value by design. I need to
know
how to create a report that only shows the first entry of each value. Can
someone help?

__________ Information from ESET Smart Security, version of virus
signature database 4005 (20090413) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4005 (20090413) __________

The message was checked by ESET Smart Security.

http://www.eset.com