Add two Premium Fields in access 2003

[ragha]

Hi



I m new to access coding,i m working on appilication,i strucked here in calculating two fields

In my application front end form i have 2 fields Premium1 and Premium2,in my report design view i need to add this two.so i m trying to write some this like this in my text box control source i.e
Forms!FormName!Premium1+Forms!FormName!Premium2.Th ese 2 premiums are coming from database and already stored in access tables.

And I tried to use the built in function Sum and selected this two fields in expression builder also,but i dint find any use.

Plz hep me with this and let me know if you need more info.

[HiTechCoach]

I am confused here. You are making references to controls on a form.

If Premium1 and Premium2 are stored in a table, have you included then in the report's record source?

If the are in the report's reccord source then you can use this you can set the control source of a text box on the report to this:

=[Premium1] + [Premium2]

Better yet use this:

=Nz([Premium1,0) + Nz([Premium2],0)

[ragha]

Hi

Sorry to confuse you,
There two premiums are coming from form and i have to add these two and show the total in muy report.
I was trying to use ---------
=Nz([Premium1,0) + Nz([Premium2],0)
---------
But i m getting #Error.

As you said can you plz tell me what is this record set ,I m new to access

[HiTechCoach]

The error is cause becuse you do not have the field from the table in the report's record source.

Notes on terminology with Access:

Controls are on forms
Field are in tables

In general report print data from field in tables.

It is common to use a form to collect criteria for filtering a report. It is common to reference to form to show the criteria used.

You said:

These 2 premiums are coming from database and already stored in access tables.

If they are already stored in the table then why are you making a form reference.

Are you making an unbound report?