how do I work a percentage discount of a total cost

[Guest]

I am using Access XP. I am trying to give a scount when two or more bookings
are made at the same time. as an example when a person makes 5 or bookings at
the same time, the get a 10% discount.

 

[Arvin Meyer]

I am using Access XP. I am trying to give a scount when two or more bookings
are made at the same time. as an example when a person makes 5 or bookings at
the same time, the get a 10% discount.

At an appropriate point in your code, (probably after you've entered the
source data for the last calculation of that booking) force a record save
with:

DoCmd.RunCommand acCmdSaveRecord

or

Me.Dirty = False

Then build a recordset and take a recordcount. Use a Select Case statement
to determine the discount based on the recordcount. Since you already have a
recordset, I'd just cycle through it updating the price with the discount.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access