Chart - Missing first Column

[bloise]

I have created a report using Access 97. The report contains a chart. I have gone into the properties of the chart and changed the data to reflect the query. Basically
the query list each month Jan-Dec, and a count of incidents for each month. Everything works fine, except when the report is run, it drops the first column, January.

When I see the chart in design view, I see January in the data associated with the month. But when I preview the report, January is missing..

Any Suggestions,
Mike

 

[GingerR]

in the datasheet view of the chart, is January the very first column? the first column should be a title like Month or something.

what is your sql/query for the chart?
what fields are in your tables?

 

[bloise]

Thanks for the reply.

Basically, I use code to create a temp table. The table has 12 columns, each column identifies the month. There is only one data row in the table.

January 12
February 6
...

So the query is just a simple select query.

Mike

 

[GingerR]

not very relational-database-y
anyhow, the chart app is looking for a 'title', so you'll have to fake one in there.

in your temp table, make a first column and leave it blank (null)

OR

make a query that the report is based on, using your temp table, that includes a first column that is null:

SELECT Null AS Expr1, months.January, months.Feb, months.March, months.April
FROM months;

(i have a table called "months" you'll have to change the table name and put in all your months, but you should be able to get the gist)

hope this helps--g

 

[bloise]

Thanks for responding. I work alot with temp tables populating these via code. Sometimes my queries get pretty complicated and it just seems to be easy for me to take a little bit of extra time with code.

Yes, I finally figure it out thanks for your help. I include the primary key in my query which allows January to show up...

Thanks for your help..
Mike