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

  • Thread starter Thread starter rpresco
  • Start date Start date
R

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?
 
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.
 
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


rpresco said:
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
Click to expand...



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

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top