Simple Query Question

J

JIT

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?
 
D

Douglas J. Steele

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