Search results

My training database requires me to identify each training record in the tblEmpTrainHist table as either "Compliant" or "Delinquent". I thought a simple calculation in my query: RecordStatus: IIF([DateReceived]<=[DateDue],"Compliant","Delinquent") would do the trick. However, I did not...

A query I have used for years to track Outstanding and Delinquent training records has suddenly thrown me a "Data type mismatch in criteria expression" message. Query 1 calculates the DaysLate: DateDiff("d",[DateDue],Date()) This gives me a + or - number indicating the number of days. I use...

I am a long-time (20 years) Access database user in a very small pond. My database tracks quality system training for the medical device company I work for. I am not a programmer. I have developed all my functions through the tools provided by the Access application. I have had challenges with...