Search results for query: *

thanks for this - i'll give it a try - i really appreciate you spending the time on this - thanks for your help

i'm using crystal reports 10 - the purpose of the report is to transfer clinical data from our patient record system into an acess database which is then sent off to update a central nhs system.. to try and explain a little further - the main table holds a patient record - each patient will...

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

ah right - i'm using crystal reports but hacing to create a command to sort this problem out - the database is microsoft sql server - thanks for you time - i'll have a dig and se what i can find

thanks for the advice - getting a message telling me it doesnt recognise stbstr..

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

I have managed to get it working now - i think my problems were partly using Date as opposed to datevalue and using the wrong combination of fields in te running totals sections... thanks for taking the time to reply - its appreciated.... Ian

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

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