470,609 Members | 1,791 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,609 developers. It's quick & easy.

Charts in access - serious troubles

Dear All,

I wanted to do a very simple chart on a form in Access:

here is the table the chart should be based on:

Date | Weight | TimeOfDay

The format of the above fields is the following:
Data type Format Field size
Date: Date/Time General date N/A
Weight: Number General number Decimal
TimeOfDay: Number General number Integer

TimeOfDay is either 1 or 2 (morning or evening).

I want to see a line graph where Date is on the X axis, and the
individual values of Weight are plotted against DAte on the Y axis.
The series would be based on TimOfDay value (1 or 2).

In the chart wizard there are three places to drag the above three

Series: no problem here, TimeOfDay accepted as series info
Axis : This is the x axis date is dragged here no probs (can be
grouped by day)
Data: That is were Weight should go. Now the problem is that Weight
is summarized as CountOfWeight... I want individual, non summarized
values, but when I double click on the field Access says:

Only numeric field can be summarized as average, sum, etc, date, text
or key fields cannot be changed. Now as you see from above field
Weight is a numeric field...

Anyone has an idea?

Appreciate your help:

Nov 12 '05 #1
0 1055

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Serious_Practitioner | last post: by
2 posts views Thread by Gargamil | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.