Creating a report template

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

 

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