Recent content by anna76

Thanks for the info jdraw. Have tried to save it as an earlier version in mdb format

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...

Thanks, Im just going to look at that thread now as it looks really useful

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...