K
Kristibaer
I have a query on a VFP table (linked through ODBC to our sales software) to
summarize the daily value of sales orders entered. I need to group it into
weekly amounts and daily amounts but cannot manipulate the data in the query
to finish it in a report. I have the daily values totalled by day, but cannot
group it beyond that. My end result should display:
Date Daily Amount MTD Amt YTD Amt
Week of (date) with sub-totals
Is there a query criteria formula I can use so I can keep the link to the
live data?
summarize the daily value of sales orders entered. I need to group it into
weekly amounts and daily amounts but cannot manipulate the data in the query
to finish it in a report. I have the daily values totalled by day, but cannot
group it beyond that. My end result should display:
Date Daily Amount MTD Amt YTD Amt
Week of (date) with sub-totals
Is there a query criteria formula I can use so I can keep the link to the
live data?