Crosstab Column names used

[JRINC]

I created a crosstab query that has months of the year as rows and budget categories as columns. My column headings are now showing the budget category ID #'s. (1, 2, 3 ,4) I want them to show a different field from that table -- i.e. Budget category # (2221, 2252, etc) or I could use the category description (travel, per diem, etc). Either way will work - anything but the single digit ID #'s.

Thanks!

[alansidman]

Look here

http://www.datapigtechnologies.com/f.../crosstab.html

[JRINC]

Used this expression:

Mileage 2731: IIf([BudgetCategory]=”2731”,[Cost],0)

It now asks for a Parameter Value when run

Getting all zero's as sum...??

[alansidman]

Two questions:
1. Is 2731 in your budget field a number or text?
2. What is the parameter request you are seeing?
Usually, when you get a parameter request in a situation like this, it is caused by a mis spelling of a field, or Access is looking for a field that is not part of the query.

Check your spellings and field names. If this doesn't resolve, then perhaps you should post a sanitized copy of your db so that we can look at it and analyze the issue. Make sure to dummy up any confidential information. Run a compact and repair to reduce the size. We do not need to see all data, only some sampling records.

Alan