Looking for some urgent help in Access 2002. I've been given an
assignment to create a Point Of Sales project. But currently stuck in
the below requirements:

1) The front-end system (Main transaction screen) will refer to the
back-end PLU (Price Look-Up) table for the selling price conditions.
But the Front-End must be able to pick up the pricing condition
whereby:

* The initial 1 can of Coke will sell at $1.50; 2 cans = $3.00; 3 cans
= $4.00; or buy 4 free 1 (which mean with the price of $6.00 will get
5 cans). (Note: the user will be able to set his own figure based on
his needs). The system will know the moment it reaches a total
quantity of 3 for example, either scan in the barcode 3 times, OR 1
time barcode scanning with quantity of 3. = $4.00.

So, how does the system/database picks up the conditions set above?
(Note: I'm not familiar with Modules but should be alright if can
provide a detail instruction).

PLEASE PLEASE PLEASE assist me. Thousands thanks in advance.


Best regards,
Arnold, Choo

Is applying progressive discounts for quantity all the system has to do?

You could have a table called 'discounts' like this:

id: autonumber
product_id: related to id of products in the product table
qty: number of products to qualify for a discount
discount: the amount of the discount for the item and quantity.

So you might have something like this:

1, Coke, 3, .5 ( Coke at three cans gets a $0.50 discount)
2, Coke, 4, 1 ( Coke at four cans gets a $1 discount)

Steve,
Add a 'discount_type' field and you will also be able to infer whether the
value in the 'discount' field is to be taken as a monetary value (.5 =
$0.50) or a percentage (.5 = 50%).

That's the way I do it - ymmv.
Cheers,
Doug

--
Remove the blots from my address to reply
"Steve Leferve" <lefevre.10@osu.edu> wrote in message
news:cb5ifa$gg4$1@charm.magnus.acs.ohio-state.edu...[color=blue]
> Is applying progressive discounts for quantity all the system has to do?
>
> You could have a table called 'discounts' like this:
>
> id: autonumber
> product_id: related to id of products in the product table
> qty: number of products to qualify for a discount
> discount: the amount of the discount for the item and quantity.
>
> So you might have something like this:
>
> 1, Coke, 3, .5 ( Coke at three cans gets a $0.50 discount)
> 2, Coke, 4, 1 ( Coke at four cans gets a $1 discount)
>
>[/color]

arnoldcch@yahoo.com (Arnold, Choo) wrote:
[color=blue]
>Looking for some urgent help in Access 2002. I've been given an
>assignment to create a Point Of Sales project. But currently stuck in
>the below requirements:[/color]

I'd also suggest Microsoft Access Accounting Systems
http://www.granite.ab.ca/accsacct.htm. This could be a *lot* of work.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

"Tony Toews" <ttoews@telusplanet.net> wrote in message
news:c8ucd0lro0j7t31ep87i4fs4338fueq063@4ax.com...[color=blue]
> arnoldcch@yahoo.com (Arnold, Choo) wrote:
>[color=green]
> >Looking for some urgent help in Access 2002. I've been given an
> >assignment to create a Point Of Sales project. But currently stuck in
> >the below requirements:[/color]
>
> I'd also suggest Microsoft Access Accounting Systems
> http://www.granite.ab.ca/accsacct.htm. This could be a *lot* of work.
>
> Tony[/color]

STOP ADVERTISING YOUR JUNK IN THIS NEWSGROUP!