Recent content by svankley

I have a computer that CANNOT be added to a domain. I'm trying to set up some software on a DOMAIN computer that needs to talk to this NON-DOMAIN computer (over frame relay) and it won't work. I believe it's a security issue. Can you add a "non-domain" computer as trusted computer on a...

I saw on another thread that I need run cmdlets to let Exchange know what the "internet" name is for my server. I read through the whole list and can't find one particular one that does this. Is this the solution to my problem?? Thanks!!

I have an issue with our test server and setting up an Outlook client. We're running Exchange 2007 with all patches and when I set up the account server (mail.myserver.com) and name in Outlook and click the "Check Name" button, the Exchange server field is changed to our internal FQDN...

The following works perfectly in SQL Server, but for the life of me, I can't get the syntax correct for Access!! SELECT Min(NewVal) AS MinValue, Max(NewVal) AS MaxValue FROM Select A.Flow + B.Flow + C.Flow As NewVal From MinMaxTest A Inner Join MinMaxTest B...

Hmmm, how is this finding the Min & Max for any three contiguous values for the day??

You absolutely rock gmmastros!! That's perfect. Now I just have to figure out how to covert it to Access - I was just told about 10 minutes ago that the end user now wants to use MS Access for storage portability. THANKS AGAIN!!!

I'm inserting into a table, a value every five (5) minutes. How can I query for the minimum & Maximum sustained 15 minute value for the day? This would be the three lowest & highest contiguous combined values for the requested 24 hour period (i.e. 10:10, 10:15 & 10:20), or whatever the case may...

Maybe this will help The data is: 10:00 10 10:05 12 10:10 32 10:15 34 10:20 12 10:25 23 10:30 17 10:35 31 10:40 12 10:45 12 10:50 0 10:55 3 11:00 7 11:05 23 11:10 54 11:15 34 11:20 65 11:25 23 11:30 21 11:35 9 11:40 65 11:45 13 11:50 17 11:55 23 12:00 62 12:05 12 12:10 19 12:15 23 So in this...

Actually the values have to be contiguous. So any three values in a row that have the lowest sum will be returned. So I guess it would have to calculate v1+v2+v3 and then v2+v3+v4 and then v3+v4+v5 and whatever the value is for the sum of the three in a row that are the lowest, thats the one to...

I'm inserting into a table, a value every five (5) minutes. How can I query for the minimum sustained 15 minute value for the day? This would be the three lowest contiguous combined values for the requested 24 hour period (i.e. 10:10, 10:15 & 10:20), or whatever the case may be. This one has...

With everyones help, I got it to work: SELECT Q01.Date, Q01.Day, Q01.[PS1 RunTime Total], Q04.[Station 4 Run Time Total], Q05.[Station 5 Run Time Total], Q13.[Station 13 Run Time Total], Q14.[Station 14 Run Time Total], Q18.[PS18 Run Time Total], Q19.[PS19 RunTime Total], Q23.[PS23 RunTime...

The individual queries work fine but the second one (main report query) keeps giving me a "Syntax error in the join operation" error. I made the 3 changes you said in your last post. Is it one of the parenthesis in the on clauses? I keep confusing myself with the nesting. Thanks so much so far...

OK, as requested, here is the full info and queries. I inherited this problem from another company at a water treatment plant. There is a SCADA system that is used to display process data and record values to the Access database for 9 stations (1, 4, 5, 13, 14, 19, 23 & 28). Each station's pump...

Like I said - I'm an idiot! 8^) You're correct, I've been so swamped the past couple days, I can't even think straight. What I want returned is: 7 1 2006 7/1/2006 12:25:53 PM 0.10 10.20 10.3000026717782 7 5 2006 7/5/2006 2:56:26 PM Yes, there are other fields but I'm...

SORRY - I'm an absolute idiot!!! I contradicted myself. What I want display is the last time for each day that there is a record. When I copy/pasted my first question, I forgot to delete the "7 5 2006 7/5/2006 2:56:26 PM" line in the desired results - Sorry!! 8^( This is what I'm...