Access noob - Multiply Checkboxes

[robjj1988]

Hi there, I have got a databse (part of school coursework). It's for monitoring Piano Lessons i.e. schedules and students progression etc.

The problem I am having is that...

For each student in my tblLessonSchedule there is a checkbox for 'attended lesson' and a checkbox for 'paid for lesson'. Now using either a report or querry whichever is easier I need the database to find out how often each student has attended a piano lesson but not paid.

Each lesson should cost £7 so if a student attends 15 lessons over a period of 6 months but doesnt pay for 3. Then I need the database to work this out and muliply the amount of unpaid lessons by 7 to give me a total amount owed.

Thanks for any help in advance.

Kind regards.

[robjj1988]

Would it be best to use a query or a report guys? This is to difficult I might go down the pub :P

[Rabbit]

Would it be best to use a query or a report guys? This is to difficult I might go down the pub :P

You would do this with a query as a report is based on a table or a query. So you could make a query and make it look nice with a report but you would never use a report to calculate the data you want.

[robjj1988]

You would do this with a query as a report is based on a table or a query. So you could make a query and make it look nice with a report but you would never use a report to calculate the data you want.

Ok then, thats a start. Thanks very much. But how will I actualy go about doing what I asked at the begining?

[Rabbit]

Ok then, thats a start. Thanks very much. But how will I actualy go about doing what I asked at the begining?

Have you attempted to solve the problem yourself yet? What part are you getting stuck at?

[MMcCarthy]

Hi there, I have got a databse (part of school coursework). It's for monitoring Piano Lessons i.e. schedules and students progression etc.

The problem I am having is that...

For each student in my tblLessonSchedule there is a checkbox for 'attended lesson' and a checkbox for 'paid for lesson'. Now using either a report or querry whichever is easier I need the database to find out how often each student has attended a piano lesson but not paid.

You need to set the criteria for [attended lesson] = -1 and [paid for lesson] = 0

Each lesson should cost £7 so if a student attends 15 lessons over a period of 6 months but doesnt pay for 3. Then I need the database to work this out and muliply the amount of unpaid lessons by 7 to give me a total amount owed.

You will need to do this with a separate query based on the first query.

Group by the student and get count of [attended lesson] and multiply result by 7.

[robjj1988]

I have attempted this myself but my IT teacher at school has been off ill for a couple of months and my class hasnt had any help from an IT trained teacher for ages - we are all doing different databases so it's difficult to help eachother. Thanks for the help I will give it a go, problem is I'm still trying to get my hear round it all.

[MMcCarthy]

I have attempted this myself but my IT teacher at school has been off ill for a couple of months and my class hasnt had any help from an IT trained teacher for ages - we are all doing different databases so it's difficult to help eachother. Thanks for the help I will give it a go, problem is I'm still trying to get my hear round it all.

Let me know if you get stuck. Also if reposting change the query view to SQL and copy and paste in the SQL code of the query. It makes it easier for us to see what's going on.

Mary