Report

  • Thread starter aggregate sum over the periods
  • Start date
A

aggregate sum over the periods

Hi,
I made a cross tab query that showed for ProductID with sales amount in
individual month and the YTD sales amount. I had to present a monthly report
just showing the latest three months with YTD amount, not same as that made
under above query.
I tried to use DatePart i.e.
DATEPART("[SalesAmount]","ProductSales","[SalesDate]between#StartingDate#and#EndingDate#")
to restrict the record in every month column I need. It works but not match
with the individual ProductID
Who can help me?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Creating a chart on a report 2
Create report that subtracts data over two years 4
report using a subreport based on a crosstab query 5
Cross tab - complex IIF 2
Please help very urgent to give ageing report 4
Report showing abnormal information 0
Restrict a report to a given date range 2

Top