Lookup a price that was valid at a certain date

[Frank]

Hello,

to keep track of frequent price changes with several products I
maintain a simple list of 3 columns: ProductName, DateOfChange,
NewPrice.

To calculate turnover, I then need to multiply the quantities ordered
of each product with the product’s price that was actually valid at
the order date.

Is it possible to find the applicable prices for a, or any, given
order date ?

Grateful for your consideration,

kind regards,

H.G. Lamy

 

[GS]

Frank used his keyboard to write :

Hello,

to keep track of frequent price changes with several products I
maintain a simple list of 3 columns: ProductName, DateOfChange,
NewPrice.

To calculate turnover, I then need to multiply the quantities ordered
of each product with the product’s price that was actually valid at
the order date.

Is it possible to find the applicable prices for a, or any, given
order date ?

Grateful for your consideration,

kind regards,

H.G. Lamy

Normally, the pricing applied to a given order would be the current
price at the time it was written. Orders history details should show
this.

Turnover is the volume of items sold/resold in a given period. This has
nothing to do with price unless you're looking to measure sales volume
amounts based on items sold for a given period. Again, this info would
usually be found in the Orders history details.

Whether the solution you want is feasibly possible depends on how
you've structured your data. The 3 columns you mention are insufficient
to the task in that you don't mention there's a Quantity column.

Data queries can only return results that the data storage has been
structured to record details of. Same applies to retrieving data from a
spreadsheet: -you can only work with what's available to you!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion