473,326 Members | 2,173 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,326 software developers and data experts.

Fast running sum or a way to index times.

I have a table with the following

Autonumber Time Temp
1 01:00:10 500
2 02:01:10 600
3 02:00:15 650
.
.
.
.
11,759 23:59:00 700
11,760 23:59:10 600
11,761 23:59:50 650
11,762 00:00:10 750
11.763 00:05:50 800
.
.
.
.
.
23,759 23:59:10 700
23,760 23:59:15 700
23,761 23:59:55 760
23,762 00:00:15 900
23,763 00:06:50 800
.
.
.
.
Etcetera....

My issue is I need to graph the time on the X coordinate and the temperature on the Y coordinate (easy) but the clock resets every 24 hours and the logs run for days.

The time is not equal, the records are not equal, I need the x coordinates to be scaled and the times vary so I cannot graph by the log number, and I have no control over the software writing it.

I have created a running sum using Dsum, but it takes too long (it is for a multiuser application that will be used many times on many different changing data sets)

I'm out of ideas, any help would be appreciated.

Thank you.
Jan 26 '10 #1
3 1668
nico5038
3,080 Expert 2GB
As you have an autoumber, the sequence is already fixed, what's the problem in using the Graph control on this data ?

Nic;o)
Jan 26 '10 #2
I am doing a scatter plot and it needs to scale based on the time value so I can't use the sequence number.

After some doing I was able to contact the software writer and have them alter the log time to run continuous and not reset to 0 at 24 hours.

After I had the time consistant I was able to do my scatter plots.

Thanks for the help, Arne
Jan 27 '10 #3
Stewart Ross
2,545 Expert Mod 2GB
Hi. I'm glad you have resolved this one, but just in case it may help in other ways, please note that if the developers had provided you with the date along with the time you would have had the data you needed without further alteration of their log times. Maybe this is what has been done when you mention they have altered their log times not to reset each day.

Given separate log date and time values, even if these are just output as text, you could have converted them to true date/time values using Access or Excel to do so. In all the Office applications, a time value is just an instance of a date/time value, just as a date is an instance of a date/time value. They are aspects of the same data type, and can be shown separately or together by using formatting options to present the value in whatever way is required.

In MS Office, Date/Time values are stored as decimal values where the whole-number component represents the date (internally stored as a count of the number of days passed from a date of about 1 January 1900), and the decimal component represents the time (with 0.5 representing 12 mid-day, 0.75 being 1800 hours, and so on).

A date and time value generated from a data logger at set times of the day will simply increase linearly over time - by 1 for the passage of a day, by 0.5 for the passage of half a day, and so on. It is a scalar value that you can plot in whatever charting application you are using for your x/y plot.

-Stewart
Jan 27 '10 #4

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

Similar topics

8
by: Neil | last post by:
I have a very puzzling situation with a database. It's an Access 2000 mdb with a SQL 7 back end, with forms bound using ODBC linked tables. At our remote location (accessed via a T1 line) the time...
6
by: DC | last post by:
Hi, I am programming a search catalogue with 200000 items (and growing). I am currently using the SQL Server 2000 fulltext engine for this task but it does not fit the requirements anymore. ...
6
by: ruben | last post by:
Hi: I'm running a large database on PostgreSQL 7.1.3. 20 days ago the database failed with a threatening and not too descriptive error like: pg_exec() query failed: server closed the...
2
by: Jon Lapham | last post by:
I have a table that stores TEXT information. I need query this table to find *exact* matches to the TEXT... no regular expressions, no LIKE queries, etc. The TEXT could be from 1 to 10000+...
11
by: Olie | last post by:
This post is realy to get some opinions on the best way of getting fast comunication between multiple applications. I have scowered the web for imformation on this subject and have just found...
3
by: Michael Bacarella | last post by:
The id2name.txt file is an index of primary keys to strings. They look like this: 11293102971459182412:Descriptive unique name for this record\n 950918240981208142:Another name for another...
8
by: Sanny | last post by:
I have a old Pentium 2.5 Ghz Machine I use for surfing Net. I am just curious to know how much faster are the Server Machines are. Say they are 8 Core/ 16 Core??? What is the Max cores Modern...
4
by: setesting001 | last post by:
How many of you are running Fast CGI instead of the popular mod_php? I planning to change to fast cgi since my applications need around 15MB memory to handle a single request, so consider if...
9
by: Salad | last post by:
I have access, for testing at my client's site, a Win2000 computer running A2003 retail. He recently upgraded all of his other machines to DualCore Pentiums with 2 gig ram and run A2003 runtime. ...
25
by: Abubakar | last post by:
Hi, recently some C programmer told me that using fwrite/fopen functions are not efficient because the output that they do to the file is actually buffered and gets late in writing. Is that...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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.