MS Access - Calulating Number of Weeks?

Question

I am hoping somebody is able to help.

I have a MS Access Database, and im looking at putting in a field that calulates the number of weeks.

For example, a date that is the 'start' - this date may be recent, or may be even a few years old.

What i need for it to show, is how many weeks there is in between that date and the current date. With the database automatically updating as the weeks go on.

Is this possible? and if so, what formula would i need?

There is no restriction in days (only mon to fri) - i need it to do it normal - 7 day calulation.

any help would be great.

thank you

Answer 1

In the query, you could just write a formula:

=Sum(Now()-[StartDate])/7



I might now have that "now" feature typed properly, but if you search in "Help" for it, you'll probably find the right answer.

Answer 2

Check the NetWorkDays function.

Answer 3

no longer although a MACRO. MACROS are simplfied variations of the MODULES and are not as versatile. making use of a VBA MODULE you're able to try this deliver, and it is no longer as confusing because it style of feels. i did no longer choose to apply MODULES as quickly as I 1st have been given started the two, yet now i can not stand the MACROS when you consider that they are SO RESTRICTIVE. DoCmd.SendObject, acSendNoObject, "", "","<>", "", "", "YOUR undertaking LINE", "YOUR MESSAGE", fake For an entire description purely learn "SendObject" interior the get right of entry to help records. For destiny reference you additionally can learn interior the Microsoft know-how Base (it is loose!). of path, you should consistently build a greater convenient record with purely "application #fifty six" in it. that should decrease down on the document length and you're able to nonetheless get the information.