Creating a chart - help

T

Tom

Hi all,
I`m traying to create a line chart based on a query.
but the data for the vertical axis is always a function (sum, count etc..)
and that is a problem becuse I want to show the value according to the date
(which is the horizontal axis).

Please help - I hope It`s possible.

Thanks,

Tom
 
R

Rick Brandt

Tom said:
Hi all,
I`m traying to create a line chart based on a query.
but the data for the vertical axis is always a function (sum, count
etc..) and that is a problem becuse I want to show the value
according to the date (which is the horizontal axis).

Please help - I hope It`s possible.

Thanks,

Tom
Click to expand...

Use First, Last, Min, or Max. If there is only one value per date then they all
return the same value anyway.
 
T

Tom

Thank you for the quick response.

My query contain 4 fields: product (which has the critiria), Inventory and
date.
I need to show the changes in inventory over time with a line chart.
When use the chart wizard, on the vertical axis I cant put just inventory,
access does SumOfInventory and I get incorrect values.

TIA,
Tom
 
R

Rick Brandt

Tom said:
Thank you for the quick response.

My query contain 4 fields: product (which has the critiria),
Inventory and date.
I need to show the changes in inventory over time with a line chart.
When use the chart wizard, on the vertical axis I cant put just
inventory, access does SumOfInventory and I get incorrect values.
Click to expand...

But where the wizard is applying Sum() is configurable in the wizard. Just
pick something else.
 
E

eos

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
E

eos

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
E

eos

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
E

eos

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
E

eos

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
Top