Net a Crosstab result by date rage

[mtompkins]

I have a Crosstab Query that is producing the data I need to manipulate.

Basically it is -

Account Product Color TradeDate Buy Sell TotalQuantity

The TotalQuantity field is netting the buy / sell entries so by date.

In the report I need to be able to net these TotalQuantity figures (which represent product / color specific) together within a given date range.

I just don't know if I need to create a different query or do it on the reports page.

I can't seem "group / net" the data on the report as it breaks it down by date.

Please help.

 

[randysmid]

Hi,
Did you try setting up a Group level for the date field? I wrote an FAQ on this topic: [faq703-2980]. Let us know if this isn't what you are looking for.

HTH,
Randy Smith, MCP
rsmith@cta.org
California Teachers Association