Time discount on product

[tomasisko]

Hi, at school we have in Access to create a POS system. It shall allow for to change the price of goods (for example, for the selected category goods of any percentage) or a discount (or price increase) for any product. A price can be valid only for the period specified (as weekly events). How do I create, so that it could do the discount for a particular product or product category for a specific time in form and did not have to do it manually in the query.
Thank you for any help.

 

[JHB]

You need a table for Time discount on product.
Fields:

• Product
• Start period
• End period
• DiscountIncrease
• The Percent

 

[tomasisko]

Could you please expand a little bit more what to do etc.., I still do not know what to do with this. In Access'm not very good, and I need your help although I understand that nobody does anything for nothing so maybe there's a good soul to help me for free.

 

[JHB]

Could you please expand a little bit more what to do etc...

Okay I'll try by making some sample data.

SELECT Product.Product, Product.Price, Discount.ThePercent, IIf(Now() Between [startdate] And [enddate],[Price]*(1+([ThePercent]/100)),[Price]) AS DiscountPrice
FROM Product LEFT JOIN Discount ON Product.Product = Discount.Product;