Monthly Sum Queries

[omgbethy]

Hi.
I'm currently making a database for college about a driving school.
I have a table that stores the following: booking id, student id, lesson id, student forename, student surname, cost per hour and date paid. I was wondering if someone could tell me how to create a query that calculates the total of the lessons taken in a month.

Any help will be appreciated.
Thanks

 

[Gigantcus]

Hi.
I'm currently making a database for college about a driving school.
I have a table that stores the following: booking id, student id, lesson id, student forename, student surname, cost per hour and date paid. I was wondering if someone could tell me how to create a query that calculates the total of the lessons taken in a month.

Any help will be appreciated.
Thanks

Let me guess.. ICT BTEC lvl3.. ?

To the topic.. simply add all of the data in the query as normally and then at a blank field you have to write an expression. You write the expression to the first row. Sorry I don't really know a lot about it as well... I would send you a link to a video on youube but I need at least 10 posts soo.. type this in youtube without quotes "Access - Calculated Field Query"

 

[omgbethy]

Let me guess.. ICT BTEC lvl3.. ?

To the topic.. simply add all of the data in the query as normally and then at a blank field you have to write an expression. You write the expression to the first row. Sorry I don't really know a lot about it as well... I would send you a link to a video on youube but I need at least 10 posts soo.. type this in youtube without quotes "Access - Calculated Field Query"

Shockingly, HND ICT Level 4 but my knowledge on database is next to none. Thanks for your reply but I can't say YouTube has been much help either.

 

[Gigantcus]

It's quite hard to explain based on what information you gave me.. Try to play around with this to see if you get what you are looking for
Name of the field: [Field1] + [Field2]
the name of the field is how you want to name the new field that will hold in the calculated data. the [Field1] is a name of the field you want to calculate so if for example you have field called Potato, you will type in [Potato] hope this helps. Sorry I'm newbie too

 

[omgbethy]

Half good news! I'm nearly there, I've got it so you enter the month you would like to see sales for.. that's great but I can't seem to get all of the paid lessons to add together from the same field.. any ideas?!