pdvsa
asked on
Max per month
Experts, how would I be able to show a MAX for [Available WC]+[Available OD] AS AvailCumWCOD but for the month? The field the keeps the date is [date].
SELECT Import_FC_Archive.*, [Available WC]+[Available OD] AS AvailCumWCOD
FROM Import_FC_Archive
WHERE (((Import_FC_Archive.Date) Between DateSerial(Year(Date()),Mo nth(Date() )-3,1) And DateSerial(Year(Date()),Mo nth(Date() )+4,0)));
thank you
SELECT Import_FC_Archive.*, [Available WC]+[Available OD] AS AvailCumWCOD
FROM Import_FC_Archive
WHERE (((Import_FC_Archive.Date)
thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you.
Open in new window