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
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