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 TouchToneTommy 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
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
791
JimStrand
JimStrand
mhshane
  • Locked
  • Question
Query to find keywords in description field and give count
Replies
4
Views
477
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
482
Andrzejek
Andrzejek
supportsvc
  • Locked
  • Question
Query to Display $0 if no record in Quarter with YTD total
Replies
14
Views
801
supportsvc
supportsvc
supportsvc
  • Locked
  • Question
Distinct Count for Unique Number of Employees in Each Month
Replies
0
Views
219
supportsvc
supportsvc

Part and Inventory Search

Sponsor

Back
Top