Query and Prioritise Data

[Sam40mUK]

Evening all I ask this on behalf of a friend.
I have been asked to analyse data using Access to determine out of a fair number patients how many were suspected of having cancer.
The Primary Key being the Patient Number, I was trying to Query two tables today, in the Referrals Table I have the id, the date, the priority. The Visit Table has id, visit date, various observations/history.
Using Criteria I wish Query the Visit Table for visits between specific dates and then prioritise the results using the Priority field in the Referrals Table.
I would welcome any help to point me in the right direction.
Thanks Jacci

 

[Ziggy]

Bring both tables into the query design grid. If a Relationships exist between the 2 patient fields then you will see a join line between the 2 (Also if If they are both Primary ID ).

Now you can add the fields to the grid as required. The default join will return all of the records that match between the 2 tables. You can modify the join to return all from one and only those that match from the other by right clicking the line and selecting "Join properties".

Let me know if you need more help.