Search results

Am still having no luck with this. Can anyone help me here?

Access 2013

Hey Guys Just curious is it all possible to create the equivalent of a combo chart in Excel in Access? What I need is a graph showing a certain dataset as columns but also a line showing the average for that set. As an example lets take an exercise programme in a school, each child performs a...

Thanks I'll take a look

Hangover not with standing but I am still having real difficulty with this. Student A Attendance Date Status 11/08/2014 Absent - Unexcused 13/08/2014 Present 14/08/2014 Absent - Unexcused 15/08/2014 Absent - Unexcused 18/08/2014 Present The student...

Ok that makes sense, mind you I am on pint 4 now, so probably won't tomorrow lol

What I need to know is this If a student has attendance status: Absent - Unexcused for 2 or more consecutive sessions, it will notify us, these sessions may not be on consecutive days. IE they could have sessions on Monday, Wednesday and Friday, some might have only one session per week etc...

Yes but surely the count would still be 2 as the Min date would have been Monday and Max date Wednesday?

I still don't see how this will work. If someone had status: Absent - Unexcused for Monday and Wednesday last week, but for Tuesday they had status: Present, surely the min/max wont take that into account? because the min date would be the 11/08/14 and the max 13/08/14, count being 2 but...

Hey This is where I normally come confused, rightly or wrongly I try to do this sort of things on a report initially, but I get lost very quickly as my vba isn't great. Would I not need to reset the count if a student has been present again?

Hi No as say if a tutor is off on holiday another one will cover the class. Many thanks

Hi Yes dates may not be consecutive, as for instance someone might have a session on a Monday and then not again till Wednesday. We offer a very flexible approach to education for adults so they can fit it into their lives but it leaves this sort of stuff overly more complicated. Regards

Yes if a student notifies us that they cant come in we count that as Absent - Excused, which allows us to offer the space to someone else if they need an extra session. The goal is to keep occupancy at around 95% in class rooms.

Hey The status field can be set to any of the following Absent - Excused Absent - Unexcused Present Tardy

Hey All I have a Student Attendance table and it would be great if I could get some way of automatically determining if the attendance status is Absent - Unexcused for two or more consecutive sessions in order for someone to get in contact with the student. The table makeup is as...

After a few weeks working on a new marketing campaign I am back on this and still having difficulty deciding the best way to do it.

Thanks pbaldy, I was fooling around yesterday with dblookup and got nowhere but I noticed today I had the wrong notation. Thanks again

Hi Thanks for your reply. I am not sure if that will work for our situation, we use this in many places throughout the database and each time its called it calls a different recordset. Maybe an easier way would be exclude all memo type fields? We only use a couple of these Notes and...

Hey all We have using Bob Larson's excellent SendtoExcel module in our project http://www.btabdevelopment.com/ts/default.aspx?PageId=47 and are overall very happy. I however would like to stop it exporting the AuditTrail field (memo type). Can anyone one help? Thanks

Hey All I am using this http://www.peterssoftware.com/isd.htm in our project but have made a minor change so it logs people out rather than close Access completely. It works beautifully but I want to take it a step further. I was wondering could anyone help me make a small modification...