Return number of matching records

[JRT2006]

Hello,

I was wondering if somebody could point me in the right direction of research to do the following:

I have a datasheet form listing prospect information.
Each prospect is assigned a position, there can be more than one prospect with the same position.
I'm trying to get a text box to lookup the prospects position and search the remaining rows for matching positions and return the total number found.

This data does not need to be stored anywhere, just a reference value for users to look at.

 

[pbaldy]

Sounds like DCount() would work.

 

[JRT2006]

Thats what I figured, thanks for confirming.

But I cant seem to find any good information on how to exactly format it, really basic instructions.

I need the Dcount function to look up prospects position, then count all other records for matching positions.

 

[jdraw]

see Dcount

You may also want to review SQL Count and Group by
see http://www.w3schools.com/sql/sql_func_count.asp

 

[pbaldy]

Here's the syntax:

http://www.mvps.org/access/general/gen0018.htm