Search results

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

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...