Access 2007

  • Thread starter Thread starter e.winterod
  • Start date Start date
E

e.winterod

I have a form and there are two fields, one for # of pages before and one for
# of pages after. I have a 3rd field for difference between pages. What
macro/code/etc. can i use to automatically calculate the difference between
the two fields?
 
I have a form and there are two fields, one for # of pages before and one for
# of pages after. I have a 3rd field for difference between pages. What
macro/code/etc. can i use to automatically calculate the difference between
the two fields?
Click to expand...

This difference should NOT be stored in any table. What are the "pages"?
Printed pages on a Report (which will of course vary depending on the content
of the report) or are they fields within the table?

If they are table fields, simply put a textbox on the form with a Contro
Source of

= [PagesAfter] - [PagesBefore]

to dynamically calculate the difference.
 
Thank you John!!

I think I was trying to over complicate my problem.

John W. Vinson said:
I have a form and there are two fields, one for # of pages before and one for
# of pages after. I have a 3rd field for difference between pages. What
macro/code/etc. can i use to automatically calculate the difference between
the two fields?
Click to expand...

This difference should NOT be stored in any table. What are the "pages"?
Printed pages on a Report (which will of course vary depending on the content
of the report) or are they fields within the table?

If they are table fields, simply put a textbox on the form with a Contro
Source of

= [PagesAfter] - [PagesBefore]

to dynamically calculate the difference.
Click to expand...
 
Back
Top