Search results

Hi all, I am trying to work out a query for if an item is overdue, but seem to have some strange join errors as I either get not enough results or I get literally thousands too many! (Is this the cartesian product?) I have attatched a sample db of it and tried to recreate the structure (in the...

Hello everyone, Could anybody advise me on how to auto populate a field in a sub form? The main form just has the ID number and name and the sub form has five fields. 'Form Name' 'Date on form' ' Patient ID' 'Form complete' 'Notes' The first field 'form name' will have about 60 records of...