472,780 Members | 2,141 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,780 software developers and data experts.

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 1148

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Alan | last post by:
Hi there, Are there Excel charting gurus here?? If so then please read on... Sorry for the cross-post but I'm not familiar with the Excel groups. I've posted to asp.general because if I have...
by: Alan | last post by:
Hi there, Are there Excel charting gurus here?? If so then please read on... Sorry for the cross-post but I'm not familiar with the Excel groups. I've posted to asp.general because if I have...
by: Serious_Practitioner | last post by:
....or lack thereof... I use Access 2000 which I own as part of Office 2000 Professional. I've had enough trouble with glitches to ask if these are common occurrences - 1. Sometimes the "Help"...
by: Gargamil | last post by:
How can I display a chart with more than 6 columns of data? Are there third party applications? Can someone point me in the right direction here?? g
by: NickJ | last post by:
Dear all, I've encountered an unusual problem having just recently upgraded an Access 97 database to Access 2000 format and was hoping somebody could point me in the direction of a solution. ...
by: Wayne | last post by:
I have posted this problem a couple of times over the last few years but have been unable to find a solution that works. Sometimes charts in reports will display showing the design data instead of...
by: DFS | last post by:
I posted this question yesterday, and nothing but silence. I looked through cdma in Google, and it seems whenever someone posts questions about scatter charts, they get ignored. So, hopefully,...
by: Takeadoe | last post by:
I'm doubtful that the group is unbiased, but I will ask anyhow :o). If one intends to plot lots of data, primarily XY line and scatter plots, and mass produce them (in many cases I will be doing...
by: Martin Hughes | last post by:
Hi guys, I was wondering if anyone could give me some advice. I am looking to develop an ASP.NET application that will enable several workstations to access real time telemetry data received...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: lllomh | last post by:
How does React native implement an English player?
by: Mushico | last post by:
How to calculate date of retirement from date of birth
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.