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

Record count

Status
Not open for further replies.
sparky68

sparky68

Programmer
Feb 27, 2002
11
0
0
US
i have a search in a db...i want to add on the form "x of y results found"...i have a query that gets search results but how do i get its count? and how do i count the number of records in the table to get the "y" number?
 
Sort by date Sort by votes
Have you tried the DCount function?
[tt]
intY = DCount("[OrderID]", "Orders", "[ShipRegion] = 'CA'")
[/tt]
hth,
GGleason
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
225
JimStrand
JimStrand
mhshane
  • Locked
  • Question
Query to find keywords in description field and give count
Replies
4
Views
122
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
125
Andrzejek
Andrzejek
supportsvc
  • Locked
  • Question
Query to Display $0 if no record in Quarter with YTD total
Replies
14
Views
208
supportsvc
supportsvc
supportsvc
  • Locked
  • Question
Distinct Count for Unique Number of Employees in Each Month
Replies
0
Views
61
supportsvc
supportsvc

Part and Inventory Search

Sponsor

Back
Top