Simple Query Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JIT - 27 Jul 2007 18:32 GMT

I have a query that runs a calculation in steps in different fields. They
are as follows.

CompWkDay: Weekday([Completion Date])

DayAdd: 6-[CompWkDay]

CompWkFriDate: DateAdd("d",[DayAdd],[Completion Date])

Step CompMonth: Month([CompWkFriDate])

The ultimate goal is to get the number provided in "Step CompMonth."
However, I now need to do all of these calculations in one field so that I
can simply update a field in a table. Can anyone tell me how to join these
calculations together?

Reply to this Message

Douglas J. Steele - 27 Jul 2007 18:55 GMT

CompMonth: Month(DateAdd("d",6 - Weekday([Completion Date]),[Completion
Date]))

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I have a query that runs a calculation in steps in different fields. They
> are as follows.
[quoted text clipped - 12 lines]
> these
> calculations together?

Reply to this Message