Thank you!

topic closed

Dave,

I am trying to document the driver's daily activity over the course of 24 hours.

He has 4 different options: off duty, on duty - driving, on duty - not driving,...

I have attached a screenshot of my chart in design mode here.

Thank you so much for all your help so far!

I currently have a category group on the time field and a series group on an ID number and name.

I got that to work, so now I just have to work on some formatting to get the x-axis to look like this

12 01 02 03 04 05 06 07...

Dave,

I must be missing something.

I changed the interval type to number, set the min to 0 and the max to 24, set the major tick marks to 1 and...

I will try that!

Thank you, Dave!

Thank you.

Yes, I would.

I am mostly just trying to figure out the best way to go about this.

The database I am using is from another company that generates reports for...

Thank you, mar.ko.

I will give this a try.

The query is getting a start date of 1/1/current year and an end date of the current date.

After this, it aliases two views using the 'WITH' statement( With 'alias' as)...

Sorry, should have mentioned that.

[x] Enable background refresh

[ ] Refresh every XX minutes

[x] Refresh data when opening the file

These properties with the 'x' are enabled.

Before we took off the...