Search results for query: *

Hi I am trying to export a table in Microsoft Access as an xml file but I need to put the predefined structure in the xml file and not in a separate file. This is required as the application that uploads the XML file requires it all to be in the same file. The ultimate goal is that end users...

Hi Thanks for the responses. I used MichaelRed's answer and it worked great. I didn't put the dates in US format and it still worked fine. Much appreciated ap22

Hi I was looking for a result more in terms of a crosstab query. I can easily count the patients on the admission and discharge days but I need to count their presence on the days in between. ie. Admission 12/08/03 and Discharge 14/08/03 but how do I count them into the daily total on the...

Hi Staff here would like to be able to work out the daily count of patients in different wards (Emergency and Surgical ward) over a specified time period according to their ward and severity. The fields I have to work on are ward admission and ward discharge date, ward name, severity level and...

Thanks for that I used Micheal's answer as I tried mpastore but kept getting a message about using an aggregrate function which I could not solve. I am now getting everyone readmitted within 28 days. Thanks for the added comments Michael.I have to do this query every month for the hospital so no...

Hi I need to write a query that lists details on patients readmitted to hospital within 28 days of their last discharge. The table has been designed so each admission has a separate row in the admission table. I am able to write a duplicate query on the patient id so that all the patients who...