Access with Time Series

**jay567** · 11-10-2011, 06:27 PM

Hi

I have an Access database with hourly time series data. How would I create a query that calculates the difference between observations at 12:00pm vs 11:00am or the difference between yesterday and last week? Is this possible in Access?

Thanks,

Jay

**alansidman** · 11-10-2011, 06:40 PM

Depending on how your tables are structured, this may be possible. How are your tables structured? What information are you trying to retrieve? Give us some sample data so that we can give you a reasonable answer. What version of Access are you using.

**jay567** · 11-10-2011, 06:50 PM

I am using Access 2003, Access 2000 file format. I've attached an excel spreadsheet with what my database looks like.

Thanks.

**alansidman** · 11-10-2011, 08:05 PM

Here is a solution. You may want to create a search form or set parameters to allow variable searches. But this should get you started. There are three queries. You would set your criteria in the first query and then run the third one as it is based upon the first and second.

The first query accepts the criteria and returns the data to be analyzed/calculated.

The second query establishes row numbers that will allow the third query pull the prior data.

The third query then does the calculation.

Alan