Creating a chart - help

[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

 

[Rick Brandt]

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

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

 

[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

 

[Rick Brandt]

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.

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

 

[Tom]

Thank you, I changed it to max in the chart wizard and it worked.
Tom

 

[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

 

[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

 

[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

 

[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

 

[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