A plc sends the level of water in a tank to my access database every 5 mins. The table has three fields. Record number, and date are autofill and the level field contains the level of the tank in inches at the time of the sample.
I have a query for the table that grabs all of the records for the last 2 weeks.
I would like a report that from left to right is the date and time of the sample and vertically would be the level of the tank. These values would be connected and end up being a line chart.
I do this with ease in excel, but can't figure out how to do it with the access chart tool. I keep getting quarter 1, 2,3 and 4 and north, south, east, and west. Don't know where it is getting this when I selected date and level as the two fields for the chart.