Design / Ability of Access 2003

[Zeus 2008]

I am curious about data that changes over time.

If you are trying to keep track of an item and its sales, how is that
accomplished?

i.e. If you have a table with items and prices, and the prices change from
time to time -- and you record sales via these tables (in another table?)
what happens when you update the prices in the first table? Does that change
the "sales in the other table? (That would make it wroing in this case.)
OR, once the record is written in the second table, the data stays as it was
entered???

Thanks.

 

[KARL DEWEY]

Have a price table with product, date, and price. To calculate the sale use
the latest price for the product.

 

[Tony Toews [MVP]]

I am curious about data that changes over time.

If you are trying to keep track of an item and its sales, how is that
accomplished?

i.e. If you have a table with items and prices, and the prices change from
time to time -- and you record sales via these tables (in another table?)
what happens when you update the prices in the first table? Does that change
the "sales in the other table? (That would make it wroing in this case.)
OR, once the record is written in the second table, the data stays as it was
entered???

I always record the cost and price of an item in the sales transaction
table. This is not breaking normalization rules as this is the cost
and price at that moment in time.

I also save the tax percentage and dollar amount in the sales tax
transaction details table as the same rule applies there as well.

This does require some VBA code to grab the cost and price from the
item table to the sales transaction table in the various combo box
events.

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's Microsoft Access Blog - http://msmvps.com/blogs/access/