K Dales

Just a thought but could I write a marco or sql statement that would
download units produced at a specific time

ie

at 07:00 update and retreive hprod(from Database)
return to A1
at 08:00 update and retreive hprod
return to B1

as hprod is all I need as this is the counter for how much is produced.

I could then set up excel to use this data.

separate data by line number and how much is produced taking away units
produced from previous hour.

If this is possible how would I code it.

Yours scraping the bottom of the barrel now.

"Jim Ferguson" wrote:

I have a spreadsheet that gets data from using an SQL statement this is
updated with a macro and button so it can be refreshed at any time as this
info is time critical.

I want to be able to separate the units ran within an hour by filler and
unit size.
I know how to do the above but can't find any info on how to download info
by the hour.
ie need to know how many units ran from 06:00 to 07:00.
When looking at the info from the database I can't find any reference to time.

I am not an expert on SQL or Macros so need help.

Can I use a macro to retrieve the data by the hour and if so how.
Would it be better to extend my SQL statement is so how.