In the cold light of another day, I think I see what I should have been doing.

I was looking at storing all results in a table so I could access...

The project I have is a few electricity meters that were already installed in our building and the management just want me to try and extrapolate the data to try...

would it be possible for you to show me how to put the results into a permanent table?

I tried , and it created a table, but it isn't the results...

Lynn,

I have gone with your original code (attached again)because:

1) the Timestamp is always in date order, so that would appear to be ok

2) There is less code and it...

ooohhh the force is strong in these ones

These Are the droids I am looking for 😀

Thanks a lot folks...

I need to work through this so i can understand it.

It's good of you all to spend the time to help.

I'll let you know

Cheers

Andy

Ok 🙂 here goes with a better explanation (thanks for the patience)

When I first asked - I had a table that had only 2 fields:

A value Field (Int) and a...

The ID is actually an Autonumber

Many thanks again - It's appreciated

Lowell,

First, Thanks for the welcome, and also the very helpful example.

Being a Newbie at SQL, this is something I need to work at to understand.

I appreciate the time you have...