Help needed for cross tab query

Help needed for cross tab query

Post by K.L.M » Fri, 01 Aug 2003 04:57:47

Hi there:

I am attempting to create a report based on a cross tab
query - I would like the report to give me my monthly
final inventory figures, then carry over that balance and
add it to the next month's figures. I can't seem to get
the months to appear in chronological order, and then I
can't get the running sum to calculate. I'm still new to
this program, and any help would be appreciated.



Help needed for cross tab query

Post by [MVP] S. C » Sat, 02 Aug 2003 01:03:08

To get the months to display, as column headers, in chronological order, use
the ColumnHeadings property of the query.

If your data is Jan, Feb, Mar, then put Jan, Feb, Mar. If it is January,
February, March, then put that.


Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!