G
Guest
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?
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?