Creating a report template

D

drawde2000

I have several queries that shows practice groups, service types and amounts
paid by different insurance (qryUnitedHealthcare, qryCigna, qryBlueChoice) -
Amounts paid differs for each insurance; other fields stays the same. I can
create a report that shows all three fields by each insurance carrier; I will
have three reports; one for United, one for Cigna and one for BlueChoice.
However, what I want is a like a report template that will just give me the
fields for a specific insurance. I want to automate the process of making
reports. I do not want several reports; I want just one report template and
if I want just the amount paid by Cigna, I will use the report template.

I have more insurance carriers and I don't want to keep creating reports for
each insurance. Even the title of the report should automatically change to
whatever insurance I want in the report. Is that a possibility in Access?
 
D

Duane Hookom

By "fields for a specific insurance" are you suggesting you have a table with
fields specfically for United, Cigna and BlueChoice? If so your table
structure isn't normalized which is causing your issues.

Can you provide the significant table and field names?
 

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