access Query Question

[cnewtomass]

I am trying to calculate the # of referrals in the Number of Referrals textbox on the Enter/Edit Providers form. As someone views the different providers, this field will display the current # of referrals for each provider.

The provider # is the primary key of the providers table and is the value of the ReferredBy field of Enter/Edit Patients. Any assistance will be appreciated. Thanks! -

 

[dhookom]

You haven't provided near enough information. Calculating sums/totals generally require knowledge regarding some table structures. You haven't provided any.

Please try again.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[bamafan2002]

You could develop a query that will count the referrals. I am assuming that you have a provider index code for which to count. Then create a macro that runs when the form opens it runs the referral count query and displays the number of referrals in the appropriate box.

 

[PHV]

You may consider the DCount function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886