Hi all
I am a novice access user and have been working on this access 2007 patient database that should ease the track of health records and generate invitation letters to perform specific tests. I have a selection query that filters patients I need to invite and a table with stored available visit times. I need to to create a query that links patients to defined number of free visit times e.g. for the upcoming month or so, one patient per one time record. Any ideas how to do that? Thank in advance.