Calculations in a form not printed on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,
Frist let me start by saying a I am Newbie when comes to Access, however I
am the most knowledgeable with computer stuff here at work, so I was asked to
try and create a database that would be use to process return merchandise
claims, store the claims for furture lookup and print the current claim to be
faxed to our corp office. After much reading of Access manuals and books...
I proceeded to start. I have a claim table, a claim form and even made a
claim report. I have entered 100 test claims which all print as planned
except for the following. On the form there are five columns that contain a
currency value that add up to a sub-total which is added to freight cost
which concludes with a total cost. As I go throught the claim records the
sub-total, freight and total cost all populate however these fields are blank
on the report that is printed. At this point I am lost as to find a reason
for this. I have been reading and I THINK maybe it has something to do with
bound and un-bound, however I am not sure... any help with this if I
explained it clearly would be great.

Thanks

Dave
 
On the form there are five columns that contain a
currency value that add up to a sub-total which is added to freight cost
which concludes with a total cost. As I go throught the claim records the
sub-total, freight and total cost all populate however these fields are blank
on the report that is printed.
Click to expand...

Just put textboxes on the Report; set their Control Source to the same
expressions that you use to calculate the subtotals on the Form.

This kind of data should not be stored in any table since it can be
recalculated as needed; on your Form the values are being calculated
but (quite properly) are not being stored in the table. The Report is
pulling data from the Table, not the form, so the calculations aren't
there.

John W. Vinson[MVP]
 
Back
Top