Calculate number of weeks

[Matt]

I use Access 2003. I have start and finish dates, and want to calculate the
number of weeks in a separate text box. I have tried the following:

=[Hire Ends]-[Hire Start]/7

This does not work.

Any help??

Thanks
Matt.

 

[Allen Browne]

If you want the subtraction to occur before the division, you need brackets:
= ([Hire Ends] - [Hire Start]) / 7

 

[Pieter Wijnen]

Also Datediff is better for this sort of thing

Pieter

If you want the subtraction to occur before the division, you need
brackets:
= ([Hire Ends] - [Hire Start]) / 7

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

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

I use Access 2003. I have start and finish dates, and want to calculate
the number of weeks in a separate text box. I have tried the following:

=[Hire Ends]-[Hire Start]/7

This does not work.

Any help??

Thanks
Matt.

 

[John Vinson]

I use Access 2003. I have start and finish dates, and want to calculate the
number of weeks in a separate text box. I have tried the following:

=[Hire Ends]-[Hire Start]/7

Try

DateDiff("ww", [Hire Start], [Hire Ends])

John W. Vinson[MVP]