Recent content by clatham

I have a database which worked perfectly fine until I took maternity leave and my replacement started deleting things they didn't know about and ended up breaking some of my reports. I have now managed to get everything working properly again, but I am due to go off on mat leave again in the...

That sounds like exactly what I need, however, I have no idea how to do it :(

I have a report that pulls off Student Attendance records for each group of students (i.e. 60) and has a page break between each student. I have added a parameter to the query behind the report to filter by Subject, so that the user can get a report of students who attended their class...

Thank you, I see what you mean. This now works exactly how I would expect it to.

PercResult: Format (SafeDivision([SessionsAttended]/[TotalSessions]),"Percent") This is saying I have an expression with the incorrect number of arguments. What am I missing?

Sorry, this might be yet another stupid question - where do I put this code? in the qry sql or in the module?

Thank you both, the errors have now ceased. Do I need to add something to the Module to get the field to display the calculation as a percent? In the qryAttendancePercentage the field format is set to percent, but I gather the Module used for the calculation supersedes this?

Qry Code: SELECT qrySessionsAttended.StudentID, qrySessionsAttended.TotalSessions, qrySessionsAttended.SessionsAttended, SafeDivision([SessionsAttended],[TotalSessions]) AS AttendancePercentage FROM qrySessionsAttended; Module Code: Function SafeDivision(in_Numerator, in_Denominator) '...

I don't think I did it right, I'm getting a syntax error. Should I have named the module "SafeDivision"?

I'm afraid I know nothing about modules, so this might be a stupid question; do I change the in_Numerator and in_Denominator to my field names?

Hi all, I've started getting an overflow error on the following: SELECT qrySessionsAttended.StudentID, qrySessionsAttended.TotalSessions, qrySessionsAttended.SessionsAttended, [SessionsAttended]/[TotalSessions] AS AttendancePercentage FROM qrySessionsAttended; I assume the error is being...

That's great - thank you, I've got that working now. Is it also possible to add in the summary data from a query to be viewed on the form, other than having it as a subform where it looks like a table? As above, I've created a query which looks at the total number of sessions a student could...

I've been trying to find a way around this, but I can't come up with an option for creating an easy to use input form to add new data to the tblAttendance. The raw data in tblAttendancewould be far too difficult for my data-inputter to navigate to enter what is needed. PLEASE HELP!

I have a problem with my crosstab query that the 'Recordset is not updateable' Code is below, I assume (from reading up on it) that there's an issue with a missing foreign key, but I can't see where I would add it. Table Structure attached. TRANSFORM First(tblAttendance.AttendanceCode) AS...

Thanks plog, yes I'm adding that new field to my table and will use yes/no as you suggest. (I'd have posted on the same thread, but I thought it should be in the tables section for this question?) isladogs, I think you're right and it would be similar to a college link course. Unfortunately I...