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!

  • Congratulations TouchToneTommy 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: *

  1. IanMullineaux

    how do i find first two records in related table

    Hi I have two tables in a database lnked by an id number.. table 1 contains patient details and patient 2, patient assessments. is there a way i can find, for each record in the main table, the first assessment from table two and place it in a column in the report, and then the second...
  2. IanMullineaux

    Joining tables wth non-matching fields..

    Hi I am trying to joint 2 tables together but the fields i need to use are not identical.. The EPRFRef field in EPRMain is made up of 16 digits with a letter of the alphabet in position 17. This field has been taken accros into the EPRFVulnerable Adult table but the suffix has been changed...
  3. IanMullineaux

    Averaging Times

    Hi I am new to Crystal and although I am managing to produce reports I am now stuck and would really appreciate some guidance from the experts.. I am creating a number of reports from clinical data that require the calculation of things like average ambulance call to hospital time I have a...
  4. IanMullineaux

    Dialing Telephone numbers from access97

    I have an Access97 Database and I need to be able to automatically dial phone numbers from within the database, recording start and end time of call. I also need to be able to monitor incoming calls and if the number is stored in the database, also store the start and end time of the call. Can...

Part and Inventory Search

Back
Top