Recent content by gdougher

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

I believe I am destined not to have this problem resolved...I have tried to upload my database files following the instructions provided, but I received a message that indicated my submission was "missing" a security token. So, I used the link to email "jon" at Access-Programmers, but it kicked...

Gentlemen, I will certainly post it for you, but I'm not sure I know how to do that. I'm afraid I am causing alot of trouble...I have a front and back end.

Pbaldey, of the 2100 records resulting from the query, the DateDue field is fully populated.

Hello, Paul. The [DateDue] field in the expression is actually a calculation DateDue: DateAdd("d",[AssignedTime],[NotifyDate]) using the [NotifyDate] and [AssignedTime] fields from my Employee Training History table. The records in that table contain training records that require a NotifyDate...

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