A
Arndres
Hello. I have created a report (in a letter format) where I would like to
pull the total of two fields from a query that I have built. To give
background: in the query I have added field one (premium) from table one and
field two (lep amt) (from table two) and it is called (total premium). In
the report I have a paragraph that states:
=IIf([lis package]="001"," The monthly premium for your plan is: $" &
[Total Premium] & "
If you think you...")
When I run the report the premium does not display it is blank, although in
the query the total premium displays correctly.
Is there a way that I can have this field show in the report? Thanks in
advance for your help.
pull the total of two fields from a query that I have built. To give
background: in the query I have added field one (premium) from table one and
field two (lep amt) (from table two) and it is called (total premium). In
the report I have a paragraph that states:
=IIf([lis package]="001"," The monthly premium for your plan is: $" &
[Total Premium] & "
If you think you...")
When I run the report the premium does not display it is blank, although in
the query the total premium displays correctly.
Is there a way that I can have this field show in the report? Thanks in
advance for your help.