Recent content by sbbrown9924

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.

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

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

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

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

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

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

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

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.

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

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

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

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.

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

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