Hello,
Need some help.
I'm trying to generate a graph that displays an expression from four seperate Queries, is it possible?
The first bar would show the expression from Query 1, sencond from Query 2 and so on.
Thanks,
Mike
Hello,
Need some help.
I'm trying to generate a graph that displays an expression from four seperate Queries, is it possible?
The first bar would show the expression from Query 1, sencond from Query 2 and so on.
Thanks,
Mike
A single graph can have only one RowSource. All the queries would have to be somehow included in one sql statement as the RowSource. Do you want to provide the project for analysis?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you,
I'm trying to take the expressions from the "Downtime Queries" and show a line graph, on the "Main" form for each cells downtime, per day for a rolling 30 days.
I'm having trouble attaching the project. I am trying to attach the 4 Queries, table and main form only and I can't get the file size below 600.
Zip with Windows Compression. 2mb zip allowed.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Maintenance.zip
Dah, I guess I wasn't thinking. I've attached my whole DB. I'm sure it has a bunch of mistakes but still building it.
Thanks again,
Mike
Can't add the elapsed time value. Needs to be decimal hours. Remove the Format function and use DateDiff. Remove the start and end time fields from query.
If you want all cells on one graph, a single query should serve.
SELECT Location, Today, Sum(DateDiff("n",[Cell reported down at what time],[Repair completed time])/60) AS Downtime
FROM Downtime
GROUP BY Location, Today;
Do you want bar or line graph, you reference both.
Here is the RowSource for the graph:
TRANSFORM Sum([Downtime]) AS [SumOfDowntime] SELECT [Today] FROM [Downtime Query] GROUP BY [Today] PIVOT [Location];
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I'm sorry June7 I'm just not understanding.
Got it, works perfectly. Using a bar graph. Thank you so much. Hope to work with you again.