Help needed for cross tab query

  • Thread starter Thread starter K.L.M.
  • Start date Start date
K

K.L.M.

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.

Thanks.

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

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top