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
fields:
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:
Viktor