Search results for query: *

You all have given me some good things to work on here. I took a quick look at Debra's site, and will pursue that further when I get back from some business traveling. Thanks for your help - it's great to be part of a team like this! Don

Thanks for the tip - I will look at Lakeside soon! Don

Thanks for all the guidance. I have ordered a new server, and will leave my old machine as the DC with DHCP, DNS, time, etc. - everything but files. The new machine will be primarily a file server (we also want to move user files from their desktops to a centrally managed location, since they...

We have a star topology in our enterprise, with 6 locations. At the hub, someone a long time ago decided to use the DC (which is also the primary DHCP server) as also a central file repository accessed by people from all the other locations. We are currently at a point where we cannot reset a...

Does anyone have any suggestions for security reporting? Don

Hello! We have a request from an auditor to produce a report of logon failures (bad password, user unknown, etc.). They would like to see a report by userid (to identify multiple cracking attempts) and by IP or machine (to identify attempts at multiple logonids). Being new to AD and event...

Skip, I understand most of what you say, and will be glad to try it out. First, a couple questions. How can I get a list of unique cities for the user to select? I have tried an array formula, but realize that as the table changes, I would need to constantly update the city list. Second, in...

It seems that I may not have been clear before. The data looks almost like this: Huntington Best Western 3441 Rte 60E 736.9772 Huntington Comfort Inn 249 Mall Road 733.2122 Mt. Hope Holiday Inn 340 Oyler Ave 465.0571 Mt. Hope Courtyard 124 Hylton Lane 252.9800...

Hello, I am trying to create a variable data in a spreadsheet which will create travel request forms. I cannot use VBA as many of the users have macros disabled due to paranoia. Consequently, I need to use in-sheet functions. Here is what I would like to do. Starting with a list of cities and...

Hello! I am somewhat new to VB, and would like to write a small app that would run in the systray, and either clicking or hovering would display for the user the current machine's name and IP address. We have just hidden the VNC icon from the users, and need an alternative to be able to support...

Hello! We have implemented SNMP monitoring of our servers, and would like to begin monitoring some of our key desktop units. Since these machines are located in different sites and are a mix of Win2K and XP, we were hoping there would be a way through GP to enable SNMP. Can anyone tell me...

Okay - my mistake here. I was getting a div/0 error, and so tried to use a case statement, and that is what gave me my first error about a non-aggregate field. Consequently, I will add a WHERE clause to only take records with a goal > 0, and then use a UNION ALL to get the rest of the records...

Hello! I have a problem, and hope it is my stupidity instead of a "can't be done" problem. My data rows have (subset): Location (PK fld1) Shift (PK fld2) Program (PK fld3) List (PK fld4) Goal Hours Sales What I need to do is in a query, produce a total of hours and sales per Program per...

Thanks for the help, it was the UNION ALL that I didn't understand before - I now have my query giving me what I want! Thanks again! Don

Hello! I would like to have a single query return a set of records that has (1) a Grand Total for a given date, (2) Subtotals for Date, Customer, Location, and (3) 1 to n Detail records for each (2). Can this be done in a single query, or how can I combine the results from multiple queries into...

Boy, do I feel stupid! I tried a union at one time, but did it in the SQL pane of Enterprise Manager's tables function, rather than in the SQL Query Analyzer. Once I moved there, the union worked fine. Thanks for your help - now on to some other recordset problems I have with email! Don

Hello! Here is another question that should be easy, but has me stumped. I have a table with Name1 and Name2 columns (among others). I would like a distinct list of all the entries in Name1 and Name 2 as a single list. For example, if I have Name1 Name 2 Bob Bill Joe Larry Don...

Wow! Thanks for the help! I knew it couldn't be <too> difficult, but that it was over my head. I hope I can help someone down the road someday! Don

Here are the two distinct queries: SELECT Production_Date AS PDate, Location AS Site, SUM(Hours) AS Prodhours FROM production_details WHERE (Production_Date = '10/18/2004') GROUP BY Production_Date, Location and SELECT Payroll_Date AS Pdate, Location AS Site...

Hi! I am new to SQL, and have done some easy queries, but have a problem I can't get past - thanks for your help in advance. Here's the deal: Table H contains records with hours columns (QA, IT, Vac, HR), with a key of Date, Site and Shift (one rec/Date,site,shift) Table D contains recs with a...