Search results for query: *

Thanks mate, i'm finally going get to have a play and see if it works, thanks for your time Lee

OK, how about you forget the code that i have written...i think it's causing more porblems than it's worth.... How would you do it? There is no Key for the tables, here is a layout of the tables DiscreteHistory DateTime, Tagname, Value 21 Mar 2006 08:00:00...

Hi Simon, 1. Yep...my mistake it's supposed to call 'PenFridgeSumRun'... 2. The value in @Tagname (Gis_Pen_Container_Mycom_Run_Pen) is supposed to setup up AnalogueHistory, do i need a WHERE under the SELECT to specify the date range? 3. Yeah it's records every 5 seconds for both the power...

Hi, I've got me treads mixed up....i'm trying to work out the amount of minutes that the compressor will be turned on ie. equal to 1 this the code i'm using now, but i'mnot sure that it's working... SELECT @PenHow2On = ISNULL((SELECT COUNT(*) FROM DiscreteHistory WHERE datetime...

Experts! I've been having a bit of a problem.... I have data on a compressor in two tables. One table contains the % load that the compressor is under as integer and the other table tells me when the compressor is turned on as a boolean. I want to know what the average level of load is...

Experts! I've been having a bit of a problem.... I have data on a compressor in two tables. One table contains the % load that the compressor is under as integer and the other table tells me when the compressor is turned on as a boolean. I want to know what the average level of load is...

I've found the easiest way is to use the CDO commands for sending email, that way it doesn't even touch outlook.

Cheers Bobby and 'TheAceMan1' I'll have a play around with it, but all looks good Lee

Hello Experts! OK...have a access data base working lovely, but trying to get it to startup with a few parameters. 1. Different time - I've found a way of doing a fixed startup , this is using windows scheduler. 2. Different options - Whether the startup will email and print report, just email...