Partition - Fixed Column Headings

[dynamictiger]

I am attempting to use a partition query to produce an aged equipment report.

I set up a mock up attached that explains the problem better.

I can get the query to function fine, but suspect there may be instances where the columns may be omitted due to no values returned. I would like to fix the columns, 1: Cause I have never done it; 2: I reckon it will make making my report easier.

As far as I can tell I have correctly set up the coumn headings, but most of the fields are returning blank. Anyone know how to correctly set them?

PS: Attachment is converted to 97. Don't know if it will work in 97???

 

[GumbyD]

Fixed columns

You were so close. The spacing has to be exact. in the example database that you attached all you needed to do as add and remove a few spaces in the query properties. Here is what it needs to look like to work. I figured it out by using a make table query to get the exact spacing on the column headings: " : 0"," 1: 3"," 4: 6"," 7: 9","10:" I hope that helps.