473,320 Members | 1,953 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Historical Data

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
2 1716
ChipR
1,287 Expert 1GB
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
missinglinq
3,532 Expert 2GB
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

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

Similar topics

1
by: Fernand St-Georges | last post by:
How to build a TRIGGER that copies, all the time, the data from the table on which the transaction occurs to the historical table? thanks Fernand --- Outgoing mail is certified Virus Free....
1
by: rottytooth | last post by:
A general data design question: We have data which changes every week. We had considered seperating historical records and current records into two different tables with the same columns, but...
1
by: Àèά Íõ | last post by:
hi, now, i don't know how to ask a historical query? which command? thanks! __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam...
3
by: Erwin | last post by:
I have a work assignment in which I have to put a historical archive within access which can be used for trendlines etc. It contains data about month, service percentages and numbers. Within a...
3
by: deltauser2006 | last post by:
My database consists of information which is updated every quarter. Forms will compare data from the present quarter to quarters past. I need a way to make the database save a copy of itself every...
2
by: igendreau | last post by:
I need to have a form where my users can enter job info. One thing they need to enter is "Regular Hours". What I need to do is then calculate "Regular Cost" which =Regular Hours x Regular Rate...
1
by: sbowman | last post by:
I'm in the process of creating a monthly reporting database. I've worked out all the queries which are all counts of particular field values. I need to store these values in a table for historical...
1
by: awebguynow | last post by:
I'm working in a Lamp environment, (actually WAMP), am using one of the many Calendar widgets (that has configurable formats), and have a heavy data in/data out (forms/reports) webapp. This is...
3
by: meter_man | last post by:
Is there a way to bring historical data into one field? I have activities A1, A2, A3 ,etc in a history table. I need to check for the presence of that data and bring it back if it exists for a...
11
by: David Mathog | last post by:
In the beginning (Kernighan & Ritchie 1978) there was fprintf, and unix write, but no fwrite. That is, no portable C method for writing binary data, only system calls which were OS specific. At...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.