Divide/Count/Avg

  • Thread starter Thread starter open a adobe file from a command button
  • Start date Start date
O

open a adobe file from a command button

I have 2 columns with dates in both, I would like to determine how many days
are between the 2 dates, total the number, then divide that by the number of
records in the table . Can someone help???
 
To get the number of days between the 2 dates, use a text box with
ControlSource of:
=[Date2] - [Date1]
substituting the name of your date fields.

To get the average number of days, put a text box in the Form Footer
section, and set its ControlSource to:
=Avg([Date2] - [Date1])

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

"open a adobe file from a command button"
 
Allen, Hi. Thank You very much!!

Allen Browne said:
To get the number of days between the 2 dates, use a text box with
ControlSource of:
=[Date2] - [Date1]
substituting the name of your date fields.

To get the average number of days, put a text box in the Form Footer
section, and set its ControlSource to:
=Avg([Date2] - [Date1])

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

"open a adobe file from a command button"
I have 2 columns with dates in both, I would like to determine how many
days
are between the 2 dates, total the number, then divide that by the number
of
records in the table . Can someone help???
Click to expand...
Click to expand...
 
Back
Top