Recent content by JamesDoingAccessStuf

Hey again isladogs, I appreciate your offer of help. I found a work around by using VBA record set to merge both data sets together (day and time). The outcome is a less visually appealing chart but it works. I don't feel I have the time or desire to try and further try and figure out what...

Can I override this and make it group the way I want it to? Thanks again

Interesting. When I paste the following into the row source: SELECT TblStudentVisitsToLibrary.[DayOfReadingVisit], TblStudentVisitsToLibrary.[TimeSlot], Count(TblStudentVisitsToLibrary.[VisitID]) AS CountOfVisitID FROM TblStudentVisitsToLibrary GROUP BY TblStudentVisitsToLibrary.[TimeSlot]...

Thanks isladogs, it seems I'm using the modern charts as I believe I used the insert chart dropdown menu

Hey everyone, I've been building this database for a local library reading program. I'm now trying to generate charts to show various reading visits throughout the day. I created the query below to display the data in a way that makes sense, that is grouped by day and then time: SELECT...