Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by sbbrown9924

  1. sbbrown9924

    Problem with SELECT DISTINCT date query

    PHV; You were right - thanks. The query runs fine now. I was testing it through Dreamweaver. Testing w/o DMX and it works fine. Same with the ORDER BY problem - that works too.
  2. sbbrown9924

    Problem with SELECT DISTINCT date query

    I wrote this query that counts the number of patients seen per day in an ER: SELECT DISTINCT Format(TriageTime,'mm/dd/yyyy') AS [fDate], COUNT(Format(TriageTime, 'mm/dd/yyyy')) AS [ctPatientsPerDay] FROM ARCHIVE GROUP BY Format(TriageTime,'mm/dd/yyyy') that works ok. However, when I go to...
  3. sbbrown9924

    using "partition"

    Golum; Yes! Thanks Golum - I could not find that page.
  4. sbbrown9924

    using "partition"

    Hello; About 6 months ago I had asked for assistance to help count the number of patients seen in an ER by hour. The query was: SELECT Partition(DateDiff('n',TriageTime, InRoomTime)/60, 0, 10, 1) AS [WaitingTimeRange], Count(*) As [Patients] FROM Archive WHERE (TriageTime > #DateBegin#)...
  5. sbbrown9924

    Setting NTFS permissions with XP Media Edition

    Never mind. I found this post deeper in the forum. If you have a missing Security tab for file properties in WIN XP PRO you will have to go to: Windows Explorer Choose Tools > Folder Options... Go to the View tab Uncheck Use simple file sharing at the very bottom Found this in the Windows...
  6. sbbrown9924

    Setting NTFS permissions with XP Media Edition

    I just got a new computer with XP Media Edition. Media Edition comes with IIS 5.1 but when right-clicking to set permissions, there is a sharing menu but not permissions like IIS 6. I am getting several errors related to files not having appropriate IUSR_MACHINENAME permissions. How are these...
  7. sbbrown9924

    Select last three records in a recordset

    mp9, lespaul; Ah, the missing link! In the reference guides I use, they don't mention reserved words. Thank for helping me withe query.
  8. sbbrown9924

    Select last three records in a recordset

    What if I want to compute the average of the three values derived from this query? SELECT TOP 3 round(DateDiff('n', DispositionTime, NOW())/60,2) AS TopThree FROM TrackingMain WHERE DateDiff('n', DispositionTime, now()) > 120 AND AdmittingService=1
  9. sbbrown9924

    Select last three records in a recordset

    mp9; Cool. That works great! Do you have a good reference source you can recommend? I cannot find any information about TOP in ADO, VBscript, ASP or JET SQl reference guides. Is TOP part of VB basic? Thanks again.
  10. sbbrown9924

    Select last three records in a recordset

    Never mind.... Select LAST(TriageTime) AS LastTime, LAST(TriageTime) - 1 As SecondLastTime FROM....
  11. sbbrown9924

    Select last three records in a recordset

    How would I select the last three records in a recordset?
  12. sbbrown9924

    Count days that a person worked

    I need to write a query that will count how many days within a given time interval (defined by param_DateBegin and a param_DateEnd parameters) a worker worked. The table SocialWorkLog is a log that records encounters with ER patients. Each record is datetimestamped. So if a worker sees one...
  13. sbbrown9924

    Compare string values from two tables

    xwb; The TrackingMain table is only 40 records - each record represents an Emergency Room bed. Probably the client-side script to go through the table would be best. Part of my question was out of curiosity. I've been learning jet sql and vbscript and now am starting to get into ado. Thanks.
  14. sbbrown9924

    Compare string values from two tables

    In a repeat region whenever there is a match of string text from one table compared with another, then I would like to set the background of one of the table cells. Something like... <td background="<%IF {a match exists between strings} Then...
  15. sbbrown9924

    same result using avg and max

    Golum; You were way right - way to many GROUP BY fields. Thanks - also, I didn't realize I could use IN instead of multiple OR's. I always learn something new from you. !! Steve
See more

Part and Inventory Search

Back
Top