N
neenmarie
I have a table containing customer shipping requirements that are received
weekly against blanket POs. It consists of:
[ItemNumber], [DateDue], [QuantityDue], [ReleaseNumber], [ReleaseDate].
I'm querying out the Max Release date and then linking that back up to the
table in another query to show me only the most recent customer release for
each item number.
I need to group and sum items in a query by week, showing the actual date of
the first day of the week. I see how to do this my month, quarter or year.
I tried these and attempted to modify them in some way to give weekly totals
but haven't been successful.
I attempted to modify the following by changing 'Qq' to 'Ww' (just hoping)
and the '4' to '52' and the 'q' to 'w'. - No such luck.
MaxOfMasterDate By Quarter: Format$([RelReportSubD].[MaxOfMasterDate],'\Qq
yyyy')
MaxOfDateDue By Quarter: Format$([RelReportSubD].[MaxOfDateDue],'\Qq yyyy'
Year([RelReportSubD].[MaxOfDateDue])*4+DatePart('q',[RelReportSubD].[MaxOfDateDue])-
Year([RelReportSubD].[MaxOfMasterDate])*4+DatePart('q',[RelReportSubD].[MaxOfMasterDate])-1
I need to do this in a query not a report because I'll need to do some
additional calculations against the results of this query.
Pls help.
Janine
weekly against blanket POs. It consists of:
[ItemNumber], [DateDue], [QuantityDue], [ReleaseNumber], [ReleaseDate].
I'm querying out the Max Release date and then linking that back up to the
table in another query to show me only the most recent customer release for
each item number.
I need to group and sum items in a query by week, showing the actual date of
the first day of the week. I see how to do this my month, quarter or year.
I tried these and attempted to modify them in some way to give weekly totals
but haven't been successful.
I attempted to modify the following by changing 'Qq' to 'Ww' (just hoping)
and the '4' to '52' and the 'q' to 'w'. - No such luck.
MaxOfMasterDate By Quarter: Format$([RelReportSubD].[MaxOfMasterDate],'\Qq
yyyy')
MaxOfDateDue By Quarter: Format$([RelReportSubD].[MaxOfDateDue],'\Qq yyyy'
Year([RelReportSubD].[MaxOfDateDue])*4+DatePart('q',[RelReportSubD].[MaxOfDateDue])-
Year([RelReportSubD].[MaxOfMasterDate])*4+DatePart('q',[RelReportSubD].[MaxOfMasterDate])-1
I need to do this in a query not a report because I'll need to do some
additional calculations against the results of this query.
Pls help.
Janine