By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,073 Members | 1,253 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,073 IT Pros & Developers. It's quick & easy.

Historical Data

P: 1
I am creating a Inventory database in Access 2007 and they want to be able to look at the past locations of where the equipment was. The Primary key is an Asset Number and I would like to just save the history of the location. When they change a location I want to keep the old location is a History table by Asset number. Is there a way to do this?
Aug 5 '09 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,287
If you have dates, you could have a History table with
AssetNumberID, LocationID, StartDate, EndDate
That way, you can easily create a query to see where equipment was on or between certain dates, or just list the locations ordered by date.
Aug 5 '09 #2

Expert 2.5K+
P: 3,532
As Chip said, you'd obviously have to have beginning and ending date fields for each equipment deployment, but you don't really need to have a separate history table for this, you can simply query for the current deployment by pulling records that have a Null value in the ending date field, and pull locations for a given time period, as Chip also suggested, depending on the dates!
Aug 5 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.