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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

selecting only one record

Status
Not open for further replies.
cc5305

cc5305

MIS
Oct 4, 2000
70
US
I'm creating a report based on a sql query from Query Designer. But in the report, I need to count the number of records the query returns and display only one record. Does anyone know how I can achieve this? Thanks. [sig][/sig]
 
Status
Not open for further replies.

Similar threads

nerdygirlgear
  • Locked
  • Question
Selecting one Record in Group for Sum
Replies
10
Views
324
nerdygirlgear
nerdygirlgear
MusicMan123
  • Locked
  • Question
Record Selection Formula Help
Replies
0
Views
119
MusicMan123
MusicMan123
jchewsmith
  • Locked
  • Question
Best Practices for linking two data sets into one 1
Replies
2
Views
112
IdoMillet
IdoMillet
petejigsaw
  • Locked
  • Question
Suppress group if it contains both specified detail records
Replies
3
Views
152
lbass
lbass
cpjeffm
  • Locked
  • Question
Parameter / Record Selection option to include or exclude NULL values
Replies
3
Views
207
fisheromacse
fisheromacse

Part and Inventory Search

Sponsor

Back
Top