I am running a query and wanted to get a weekly production total from Monday through Friday for the year. I have been playing around with it but have yet to come up with an answer. Any suggestions?
I am running a query and wanted to get a weekly production total from Monday through Friday for the year. I have been playing around with it but have yet to come up with an answer. Any suggestions?
Are you saying that you want the total Production for the whole year but only for work done from Monday through Friday?
Not any work done on Saturday or Sunday.
Is that correct?
I figured it out. I did a
DatePart("ww",[trade_date]) with the Sums for the fields that I wanted summed.
I then created another query with
WeekatePart("ww",[trade_date]) and [Trade_Date]+6-Weekday([Trade_Date],1)-7 to fiure out the last Friday of each week.
I linked the 2 queries with the DatePart and years and created a crosstab query that worked great.
Nice work!!
All the best!
Thanks for the help.