Search results

Hello I have made some progress I have run a report which sorts everything by patient, so I now have a list of patients who have blood and csf results and when they were sent. It runs to nearly 300 pages though. I need to limit this to patient who have had blood and csf results on the same...

Thank you again. I am not sure if I am explaining things properly Each record is currently a single row in Excel. The fields in each record are, in simplified form: Specimen number Specimen type either blood or csf Patient number Date of result Result information one Result information two...

No, each row is a lab specimen number. It is all in one sheet.

How will the filter provide an answer to: "show me all the patients who have a result for both csf and blood" I need each patient in as a row.

Hi It is very very kind of you to go to the trouble of making a guide for me but I think I have not been totally clear in what I need to do. I have a table. I can select for all of the relevant sample types using the filters in Excel. But The data is arranged by lab specimen number not by...

Hello Thanks Mac OS Lion Excel for Mac 2011 or Excel for Windows 2007 running in a Windows XP VM I am fairly happy using filters from tables in Excel and simple queries in Access but I can't think where to start with this one.

Thank you I have it in a Excel table at the moment but can easily get it into Access I am not sure how to get from the current list of records of lab specimens to one arranged by patient numbers which meet the criteria.

Hello I have a simple database query which I am sure that Access (or even Excel) can do easily but I can't think of the right way to go about it. The relevent data is arranged in a single massive table. There is a series of fields with demographic data, then a series of dates when the lab...