Search results for query: *

Thanks for all of your help much appreciated. 8i does have some analytical functions, i've used lag before.

Thanks SantaMufasa this looks to be just what I need. regards

Thanks for replying LKBrwnDBA but doesn't that just give a row per surgeon with duplicate op details? I want to be able to have all the surgeons on a single row with the op data, using one query if possible. regards

Hi can any one help me please, I have two tables, OP that holds surgical operation details and MED that holds the medical staff associated with an operation. The MED.s_role indicates the role of the medical staff eg. S1 - Principle Surgeon and S2-Assistant Surgeon. When I first ran the query...

Hi T Many thanks for your help, this exactly what I needed. regards Ian

Hi I have been asked to provide the time between cases (Turn Around) in a report and I'm stuck, I have no idea where to begin with the SQL query. We have a single table in a database that holds patient records including the start and end of each operation and session identifiers (Theatre, Date...

Thanks for the reply, the Theatre is a text field, the Date and time fields are standard Oracle datetime fields. The Date field holds the datepart of the operation date with the timepart always 00:00:00 eg 01/03/2009 00:00:00. The Start and Finish fields hold the timepart of the start and...

Hi I have been asked to provide the time between cases (Turn Around)in a report and I'm stuck, I have no idea where to begin with the SQL query. We have a single table in an Oracle 8 database that holds patient records including the start and end of each operation and session identifiers...

Hi I have a table within an application which I am querying via SQLPlus. The table holds information about medical staff and their roles tied to an operation date and theatre eg. Theatre Date StaffID Role CA01 28/12/06 LLOSN S1 CA01 28/12/06 WHEP S2 CA02...

Hi I am trying to convert a simple Access query IIf([act_start]<[start_time],[start_time],[act_start]) AS insesstart into an Oracle statement (fairly new to Oracle SQL) basically it compares an actual start time (act_start) with a planned start (start_time) if the actual is less than the...

Hi I have deployed a number of RS reports which are accessed via IE. To make access to these reports easier I created a shortcut to the page on the desktop. To further aid the users I entered the userid and password and ticked the save password option. So the users can now just double click on...

Hi Can anyone help me please, I've tried our IT Support staff but to no avail! For the last five years I have used a set of macros to import CSV data into an Access 97 database. Each macro first clears all records in a temporary table and then imports the new data using Import Specifications...

Many thanks for that Jeremy, I had tried your previous solution too with no success, but your final solution works great.

Hi I'm rather new to VBA but I found and adapted this code to reorder the records of table using a list box on a form curtesy of a chap called Greg Davey I think. Private Sub cmdUp_Click() Dim intSelected As Integer Dim db As Database Dim rs As Recordset intSelected = Me.lst1.Column(0...