Search results

Yeah, that's what I've been trying but it always ends up displaying the duplicates. I.E. if the first query has a record "Admitting_Number: 234, Num_Of_Scans: 2". Then when I create a new query joining this with the original table on Admitting_Number and include the Last_Name I'll get two...

I have a table in a healthcare patient database that stores Admitting Number, Scan Number, Last Name, and some other fields detailing the scan. Each patient can have multiple scans and I'm trying to design a query that lists how many scans each patient has had by finding all the duplicate...

I know. I'm not looking forward to it. One good thing is 449 of the fields are calculations so I can get rid of most of those. It's a huge mess though. There's stupid things like a study number field and another field called study number header which is a calculation that is just "=study number"...

Great. Access it is then.

I'm redoing a patient info database for a healthcare facility (right now it's a flat Filemaker db with 869 fields and 4000 records) and I had pretty much decided to move it over to access but I was talking to one of the database guys at the local University and he mentioned that if there is...