Show for then one policy number if applicable in a form

C

CAM

Hello,

I have a standand form which shows one record at a time. The record is
consist of a Policy Number and Billing Type. What I want to do is somehow
in my form shows if the user looks for a particular policy number that the
form perhaps in a lable or text box or a subform shows the user that their
are X many policy numbers in the table. The table is call Audit Inventory.
I just don't know how to do it. For exampe if the use search for policy
number "xyz" the form will show that their are 3 policy with the same policy
number. Thank you in advance.
 
L

Larry Linson

Check help on the DCOUNT domain aggregate function. It should do what you
want.

Larry Linson
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top