CODEWITHSUNDEEP
ms-accesscountlistbox
raycjones
raycjones

Reputation: 11

Adding multiple listbox results in Access 2007

I am creating a form that will show the total cost of a rental based on:

total time used the amenities selected

Right now I have the total time used calculated and reported in [Text31]
We charge $250 for the first 3 hours and then $100 for each additional hour.

I show this as: =([Text31]-3)*100+250

We also charge $50 for each amenity selected. There are three: Kitchen, A/V Equipment and a Stage. They are shown in a listbox that allows multiple selections. I would like to add $50 to the total when a check box is selected.

Is there a way to count the items selected so I could then multiply the count by 50? Then I could add that to the existing total.

Upvotes: 0

Views: 24

Answers (1)

raycjones
raycjones

Reputation: 11

Thank you for the response. I have the problem figured out now. I used the formula below to add $50 when an item in the listbox was selected.

=([Text31]-3)*100+250+([Amenities].[ItemsSelected].[Count]*50)

Upvotes: 1

Related Questions