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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ibib3
  • Content: Threads
  • Order by date
  1. ibib3

    Select Sub Query

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

    [b]Turn Around Time[/b]

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

    calculating Turn Around time

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

    Matrix view

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

    Decode with dates

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

    Reporting Services Web Report access

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

    Access 97 and CSV import error

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

    re-order of list box problem

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

Part and Inventory Search

Back
Top