Jump to content

Microsoft Access help - Price History

barryonepointfour
 Share
Posted

Hey guys, not sure if this is the correct place to post this but I need some help.

 

I'm creating a database for a DVD/blu-ray rental service. At the moment I'm trying to add a variable price field. I need it to be able to be changed at any stage, yet any sales made before the change must be recorded with the old price.

I have attached an image of my current relationships with all the fields they contain showing.

 

Does anyone know how to make a price field does what I need? I will also need to be able to say this customer made 3 orders today, therefore they have to pay £X, but that I feel I'll be able to do with ease.

 

Thanks for any help guys, much appreciated.  

post-15572-0-28253300-1388243208_thumb.p

CPU: Intel i7 3750k @4.4 Ghz | Case: Poor | Motherbord: Gigabyte GA-Z77X-UD5H  |  GPU: EVGA GTX 650 ti |

Power Supply: Seasonic 650W G series | Monitor: HKC2612A | Keyboard: Corsair K60  | Mouse: Func-MS3 | Headset : Sony MDR - V6

Link to comment
https://linustechtips.com/topic/94476-microsoft-access-help-price-history/
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Operating Systems

×