Search results for query: *

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...

I still get 2 listings for the 5th. Query result: Month Day Year Expr1003 Pump 1 Daily Runtime Pump 2 Daily Runtime PS1 RunTime Total 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 7 5 2006 7/5/2006 12:25:53 PM 0.10 10.20 10.3000026717782

I have 1 table called T_WWPS_1_Daily_Values' with 3 columns ('Date', 'COL1', 'COL2'). What i want to do is generate a report of the Pump Runtimes. Everything works fine except - if, as seen below, there are 2 readings for the same day, Month Day Year Date Pump 1 Daily Runtime Pump 2 Daily...

Sorry, the 3rd sentence should read: Is there a way to do a query I can put into a report that will return the parent/child recordsets grouped by the Prod_ID WITHOUT the zero or Null columns for each of the 3 groups.

I have a SQL2000 database that contains batch data. In this example it's a cookie dough plant. I want to do a query to group the 3 types of batch runs below based on the prod_ID field but I don't want any blank or NULL columns returned. Is there a way to do a query I can put into a report that...

I actually used this: If FindWindow(vbNullString, "Adobe Acrobat Standard") = 0 Then ' means Acrobat not running Shell "C:\Program Files\Adobe\Acrobat 6.0\Acrobat\Acrobat.exe", 6 Sleep 1000 ' Give it a sec to open End If Thanks for all your suggestions, Steve