aged receivable report based on query

[ldfitzts]

Hello,
I made a report based on a query to age commission amounts in 30 day partitions. I'm using Access 2007.

The problem occurs when there are no amounts for a particular column (for example the 61:90 column). When I open the report I get the following message: The Microsoft Office Access database engine does not recognize 'qAgingCommissions.[61:90]' as a valid field name or expression.

I'm using a crosstab query with the following expression in the field box for the column heading: Partition(Now()-[ShipDate],1,120,30)

I would like the report to always have a 0:30,31:60,61:90, and 91-120 (or just 90+) columns.

I'm very new at this, any help would be appreciated.

Thank you,
Dorothy

 

[Dennisk]

You can specify what column headings you require on a crosstab whether there is data or not. Open Query properties and enter each column required in quotes seperated by a comma.

 

[ldfitzts]

Thank you, Dennisk

The crosstab query I'm using is a sample I found on line, so I haven't figured out how to break it down into separate columns.

It's also been suggested that I use llF in separate columns instead of the Partition function.

I'll see what I can do. Thank you so much.

Dorothy