Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count once in report

Status
Not open for further replies.
teebird

teebird

Technical User
Dec 11, 2001
239
Can anyone help me with this please.

I have a report based on a query that has duplicate numbers in it. I only want to count each number once on my report.

Thanks
tee

 
Sort by date Sort by votes
Not 100% sure I understand your problem, but have you tried Select Distinct in your query instead of Select. This would eliminate the same number being displayed twice.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
243
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
274
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
242
dhookom
dhookom
monkeysee
  • Locked
  • Question
Muti Page Report 1
Replies
5
Views
238
dhookom
dhookom
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
254
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top