select data from a form and send it to a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that pulls item information and cost from a query. I've
defined markup calculations in the query that display in the form. I want to
choose (Check box) a markup % (already defined) and have the data stored
into a table. For example.
Item:12345, Cost:$10.00, Markup 10% $11.00, 15% $11.50, 20% $12.00. If I
check 15% have that price and item detail sent to a table but exclude the
other prices.

I'm sorry if this got duplicated!
 
In your OrderDetail table, use field like this:
ItemID the item number
CostEach Currency. Your cost price
Markup Number (double) The percentage.
Quantity Number How many of this item sold.

You can use a combo box to hold the markup values if you wish.

Now create a query that calculates the extended amount:
Amount: [Quantity] * [CostEach] * (1 + [Markup])

For an example, see the Orders form in Northwind. It is based on a query
that uses discount: exactly the same as you need, except markup is added on
instead of subtracted.
 
Back
Top