help with database (1 Viewer)

[5JD4NC3]

i am trying to make a bills page on my access database!
In one of my check boxes i have genre of dance and price of genre next to it.
My next check box is number of lessons.
I want to make a total price for each genre to times number of lessons*genre of lessons(which has each price next to it)

After that i want to add all my total genre prices toegther to make a total price for a bill

It looks like this...


Genre of dance/Price per lesson No.of lessons Total for genre
Genre of dance/Price per lesson No.of lessons Total for genre
Genre of dance/Price per lesson No.of lessons Total for genre
Genre of dance/Price per lesson No.of lessons Total for genre
Genre of dance/Price per lesson No.of lessons Total for genre
Genre of dance/Price per lesson No.of lessons Total for genre

Total price

Please answer!

Thankyou much appreciated!!

 

[vbaInet]

If I understand correctly, for the first step, i.e. Total for genre, what you want is a totals query. See these links:

http://www.fontstuff.com/access/acctut04.htm
http://office.microsoft.com/en-us/access/HA100963101033.aspx

1. Create query
2. Group by Genre
3. Sum No. Of lessons

On the form you multiply the Sum by the price.

For the final bit, you:

1. Place a text box in the FOOTER section
2. In the control source of the text box you put something like SUM([Total_for_Genre]).

Do a search on the sum function.

NB: Next time please use a more descriptive name than "help with my database". Something like "how to perform a totals" would be more appropriate.