Recent content by mrenwick

I am still trying to get this query to work, sorry to play the dumb blonde here but, the Completion date that you mention does this have to be a separate field for each type of training? At the moment I have a column for each training with a date in it.

So how do I get the data out that I want????

Sorry Bob I have limited knowledge of Access, what is a normalised database ??

I don't fully understand what you mean. Also, I would like to run one report/query to show training due next month for all employees. Will atempt your suggestion anyway. Thanks Mich

Yes eg. Name Tractor Forklift Crane Fire Safety Health & Safety J Bloggs 25/11/08 05/12/08 17/01/09 27/03/09 22/02/09 A Smith 17/01/09 25/01/09 09/12/08 24/02/09 10/03/09 and so on. I want to be able to run one report/query that shows any...

Hi All I am relatively new to Access databases. I have a Database that tracks training completed by memeber of staff, some of this training has to be refreshed every 3 years. My table contains all the due dates for different types of training for each employee, so I tried to create a between...