I have a field I am trying to get qtrly summary. The field is[back order} which is the result of an expresion of [ordered quantity]-[Delivered Quantity]. I am trying to take the result and sum it quarterly. The date field I am using to do this is: [Plan Del Date] this field is storing the dates as short date format. The end result I am looking for would have the column headings of: QTR1, QTR2, QTR3 and QTR4 then show the total number of items on back order. any ideas??
I tried crosstab qry however it does not like to work with qry by form for the date range and Item number I want to look up.
I tried crosstab qry however it does not like to work with qry by form for the date range and Item number I want to look up.
