Yes I have all fields in the table. I started with that. Here are the
fields listed in the table....then also they are fields on my form.
First Name - entered manually
Last Name - entered manually
OSHA 10 - date entered manually
CPR Expires - date entered manually
1st Aid Expires - date entered manually
Todays Date - autofills
# of Days Left on CPR - calculated field takes [CPRExpires]-[Today'sDate]
# of Days Left on 1st Aid - calculated field [1stAidExpires]-[Today'sDate]
OSHA Raise - this fills in with $.10 if there is a date entered in OSHA 10
listed above
CPR Raise - this fills in with $.10 if the # of days on CPR is > 0
1st Aid Raise - this fills in with $.10 if the #of days on 1st Aid is > 0
Total Pay Increase - takes the sum of the three fields directly above.
All these calculations work great on the form. When looking at the table
ONLY the entered manually fields show data. The others are blank, which
in
turn generates a blank report.
Thanks!!
Damon Heron said:
What are the three fields that are used for your calculation? Are they
stored in the table? If not, perhaps they should be.
Damon
I see where I can put that calculation in for the report field - however
it
pulls information from the table and the table isn't registering the
amounts
that have been input from the form. Let me explain a bit.
I have (3) fields in my form that will add or subtract to a "total pay
increase" dependant on whether certifications are up-to-date. So my
"total
pay increase" field (needed for report) should be the sum of those
three
fields. I have that formula in for the form. When looking at the
form,
all
the calculations are correct. The "totaly pay increase" field adds the
(3)
together.
To generate a report that only shows the employee name and pay increase
I
have to pull from the table. It pulls in the employees name but
because
there is no data being saved to the table for the "pay increase" field,
it
ends up empty when I generate the report.
:
Shelleo71 wrote:
In my Access form I've set up for entering data, only the
information
that is
typed into the fields is saving to the Table. I have several fields
that are
calculated/formulated dependant on the answers typed in. I need to
generate
a report with this information but cannot do that because it's not
saving to
the table.
Of course you can generate that report - but saving calculated fields
would - in most cases - not make any sense.
Just generate a report and with the report's field do the same as in
the
form.
Volker
