Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

"Week Ending" formula

Posted on 1998-05-08
1
Medium Priority
?
1,077 Views
Last Modified: 2008-07-03
I have a database with a date field, and would like my query to calculate the week ending
date of each record from that date field, but I can't find the formula.

Thanks much,

Michael M Murphree
0
Comment
Question by:SAGEM
1 Comment
 
LVL 18

Accepted Solution

by:
deighton earned 200 total points
ID: 1965179
If you want the week ending to fall on Friday where your daye field is [date_field] then use

[end_week] = [date_field] + (7 - Weekday([date_field],7))

Hope this works
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question