By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,019 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

Charts in access - serious troubles

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.