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!

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

Need correct syntax for Count function

Status
Not open for further replies.

Aaron1155

IS-IT--Management
Oct 11, 2002
1
US
I have an access 2k db. I would like to use a form to diplay the number of records (in the undelying table) matching certain criteria.
I am able to display the total number records in the table or querry by setting a text box's control source property to Count(*), but I need to be more specific. The only way I've been able to do this is by using seperate querries for everything and I know there must be a better way. This is probably pretty basic stuff...I'm just a novice.

Thanks!

Aaron
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top