Search results

Note - all example data information below is completely made up! I am using Microsoft Access 2010. I have a table with patients who have a disease (disease) I have a table with patients who do not have a disease (controls) Whether disease or control they have gender (male/female) and a...

I'd be very grateful for any help on this Access scenario. I have a massive table (tbl) with: id, person_id, date, resultA, resultB, resultC, resultD with about 20000 results. e.g. id 1 person_id 2 (Joe Bloggs (made up name)) result on date (01/01/2012) resultA (P), resultB (N), resultC...

I have a table with people that have disease X - tbl:[Disease X]that are being matched to disease-free "controls" tbl:[Controls] ensuring that they match gender and location. Currently I have an inner join that looks something like this: SELECT blah blah blah FROM [Controls] INNER JOIN...

I am working on a project with MS Access 2010. A person with an illness needs to matched against two people without the illness, or controls. These two controls need to be the nearest in terms of age as possible. I have matched suitable controls but I am struggling to make a query to select...