Prev: Criteria is entered in 2 columns, query is only utilizing oneset of criteria
Next: Record Selection
From: AC on 8 Apr 2010 16:25
I need to set a sale price for a product based on the number sold. For
example, first 200 will be at 100 each, and 201 to 400 will be at 90 and so
on.

Is there a way for me to put a new sequence number based on the year? First
sold of each year is back at 1?

Thank you.
From: Dorian on 8 Apr 2010 20:33
You'll need to tell us your table design, i.e. what columns you have.
You will need to have a 'date sold' column and a 'quantity' column linked to
each sale.
You could certainly run a query (or run a DCOUNT function) before you set
each price and then set the price depending on the count. There is no need to
have a counter in your table.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"AC" wrote:

> I need to set a sale price for a product based on the number sold. For
> example, first 200 will be at 100 each, and 201 to 400 will be at 90 and so
> on.
>
> Is there a way for me to put a new sequence number based on the year? First
> sold of each year is back at 1?
>
> Thank you.
 | 
Pages: 1
Prev: Criteria is entered in 2 columns, query is only utilizing oneset of criteria
Next: Record Selection