Waterline on Access Chart 2

[mclellan]

Thought I would start a new thread for this since since I sent everyone down the wrong path last time!

I am looking to add 1 or 2 hard coded lines into my access charts to identify a danger level and critical level.

I have a sample table:
process 1 date(01/01/06) level 40
process 1 date(01/02/06) level 45
process 1 date(01/03/06) level 50

process 2 date(01/01/06) level 30
process 2 date(01/02/06) level 35
process 2 date(01/03/06) level 40

process 3 date(01/01/06) level 30
process 3 date(01/02/06) level 42
process 3 date(01/03/06) level 50

Danger Level = 75
Critical level = 80

My chart should look like:
Day of Month - XAXIS
Process 1 should have 3 charted points (connected)
Process 2 should have 3 charted points (connected)
Process 3 should have 3 charted points (connected)
There should be a solid line across the board for Danger Level at point 75
There should be a solid line across the board for Critical Level at point 75

Hope someone can help!
Barry

 

[GingerR]

I'd create a table called ChartLevels, add two fields (DangerLevel, CriticalLevel), one row with your data in it (75,80). Then put this query into the query that is the basis for your chart, put those two fields into the resulting dataset. Then the resultset should have

DangerLevel CriticalLevel
75 80
75 80
75 80

etc the same for each row. Make them LINES and you're all done.

Hope this helps--g

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[mclellan]

That sounds pretty cool, of course the next question... can you tell me how I would combine both queries, or would you insert the results from both of them into a temporary table and pull from that?


Thanks!
Barry