Access 2007

[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?

 

[John W. Vinson]

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?

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.

 

[e.winterod]

Thank you John!!

I think I was trying to over complicate my problem.

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?

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.