Recent content by shaunburke

PERFECT!! It's the simple things that escape me. Thanks

I know about that function. I want to put in an expression that puts in each field the date I want to indicate

I want to use the Date () function in a query, but I want to be able to Enter the Date I want to put in, rather than it be today's date.

I don't think it's pulling correctly. Here's the SQL: SELECT [Employment data TBL].[Employee Id], [Employment data TBL].Active, [Employment data TBL].loc FROM [Employment data TBL] INNER JOIN CompletedTrainings ON [Employment data TBL].[Employee Id] = CompletedTrainings.[Employee Id] WHERE...

Events: Training ID Training Title Mandatory Annual Licensing Employee data TBL and Completed Trainings r/s's: Employee ID Completed Trainings and Events r/s's: Mandatory Annual Licensing

CompletedTrainings: Employee ID Training Title Date Began Trainer 1 Hours Date Ended Internal External Annual Mandatory EOC DDAPL Licensing Employment Data TBL: loc Active Employee ID Gender Race Education Status Position DOH dept begindate enddate termdate

I am working with a training database. I am a fresh newbie to access (more of an excel user). I need to find employee's who have never completed a certain training (DPW Medication Training), which is mandatory. I have the following tables: Employee data TBL - Contains active ee's names...

I have looked through the Forum and found some things that could help, but I am not learned in a lot of code and I'm fairly new to Access, so I'm guessing at best. I have a query that pulls employees Annual Recertification dates (annualRecertificationdates) this lists each employee (Employee...

Could you help me to understand what's happening in this code? I have little programming experience. What's happening here. It looks like it will send an email when certain criteria is met.

I have a Access training database which tracks employees trainings as well as their annual recertification dates on particular trainings. Is there a way to have an email sent to the employees automatically when their recertification date is 1 month away?