help with easy form code

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

Guest

Hi, can any one help
this has got to be easy as im new to access

I have a table with the fields roe, per, uw

I have a form with the same

I want to put the sum of row / per in the uw control source so i can run a
report and add them all togeather

I can add the sum to the forms text box but it dont store the result just
shows it


Any help!??

Cheers

Carl
 
Carl

I'm having trouble visualizing what you are describing. Could you provide
an example of data?
 
If I understand correctly, what you are doing is the correct way--using a
calculated control to display the results. You should not store this
calculation in a table, it should be recalculated whenever you need it. So,
your report should contain the same kind of control as your form, with the
same kind of formula for the calculation. You can add grouping levels to
the report and use running sums within the groups if you want a total sum
for each grouping level.
 
Cheers mark that is what I want
just got to fig it all out now
At least im on the right tracks, dont be supprised if a post comes about
reports soon!!!

Carl
 
Back
Top