Non-Existant Data Report

[AmandaBurlingham]

Hi, i have nearly completed my database and i have learnt a lot with help from here but the last thing i think i am stuck on is.... I need to design reports that show when employees do not have a particlular type of training. EG I have First Aid, I need a report that will show which employees no not have First AId. i think i am making it more complicated than need be but i just can't get my head round it!!

 

[boblarson]

What is it that shows when they do have the training? Whatever that is, do a check for NULL instead of having information.

What is your table structure like?

 

[AmandaBurlingham]

I have tried a "null" query but it came back with no records. My training report shows excatly that, all the training on the system. Am i thinking about this wrong?...would i be better basing my report/query on the training type then who has that type v's who doesn't rather than on an individual? trouble being i need to know what training a person is missing on one tidy form. (for appraisals etc)

 

[boblarson]

Need to have this question answered:

What is your table structure like?

Without that it is hard to tell you how to set up your query/queries.

 

[AmandaBurlingham]

sorry, but not sure what info you need! I have tblP_BasicDetails - (BD_ID, BD_Name, BD_address, BD_dob etc), i have tblTrainingReceived - (TR_ID, BD_ID, TR_Name, TR_DateRecd, TR_DateExp etc) and the only other table is a look up table with all the training types - (tblTraingType, TT_ID, TT_Name) Does this help at all? The query i use for expired training is tblP_BasicDetails (BD_ID, BD_FirstName, BD_LastName) tblLu_TrainignType (TT_Name) & tblP_TrainingReceived (TR_DateRecd, TR_DateEXp, TR_Comments) I just use <=Date() in TR_DateExp and it shows all out of date items.