Access 2010 Graphs

[skizzly]

Hello all,

I have a form with a graph on, and want to show two different lines on the graph, sourced from seperate tables.

The commonality between the two tables is a date.

One line shows count of people available every 15 minutes and the other would should the demand for people on the same date, every 15 minutes.

Is it possible to do this and how?

 

[plog]

You need to get your data into one query, then each row can become its own line. A good way to combine similar datasets is via a UNION query:

http://www.techonthenet.com/sql/union.php

If you need additional help, post sample data from the datasource the graph is built on. Use this format for posting:

DataSourceNameHere
Field1Name, Field2Name, Field3Name, ...
David, 12, 4/11/2015
Sally, 32, 5/6/2015

 

[skizzly]

Hi Plog,

thanks for quick response, here is the attached sample db...

Am not sure how to achieve your suggestion...

Thanks for your help in advance...

 

[plog]

Those aren't properly structured tables. Why not just do this in Excel?

 

[skizzly]

Hi

Where i am they are trying to move away from Excel.

The tables are constructed in that way to represent the data in a particular way.

Can you provide show how i would achieve what you initially suggested?

Thansk in advance

 

[plog]

Moving away from Excel for what purpose? I mean, you are now you are trying to use Access like Excel, so there's no benefit, in fact there's only difficulties as you are encountering.

If you want to move to Access, then you should read up on normalization (https://en.wikipedia.org/wiki/Data_normalization) and properly structure your data. Even then, its still very common for Excel to be used to deliver consumable data to the end user--especially in the form of charts/graphs.