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

Records Count

Status
Not open for further replies.
phpatrick

phpatrick

Programmer
Jul 9, 2006
72
BE
I know you have recordcount but can I use an sql statement to determine if a query has data (records) or not.

on the event open form he should verify if the query contains more then one record.If yes he should open a form that is normally not visible. Form.visible = true
 
Sort by date Sort by votes
SQL:

Select Count(*) From YourQueryName

This returns the recordcount from your query...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
410
Andrzejek
Andrzejek
mhshane
  • Locked
  • Question
Query to find keywords in description field and give count
Replies
4
Views
385
Andrzejek
Andrzejek
serino
  • Locked
  • Question
Adding Records between two ranges 2
Replies
12
Views
585
serino
serino
TrekBiker
  • Locked
  • Question
Find records containing another field value 1
Replies
9
Views
406
Andrzejek
Andrzejek
supportsvc
  • Locked
  • Question
How to limit the number of records based on the quantity in a field? 1
Replies
8
Views
515
supportsvc
supportsvc

Part and Inventory Search

Sponsor

Back
Top