Data Type Mismatch

[gdougher]

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 the DaysLate field in Query 2 and limit it by >0 in the Criteria field to identify my Delinquent records. I understand the concept of the "data type mismatch" but I cannot figure out where or how to change what I need to nor what suddenly happened to create the "mismatch." Thank you for any help you can give me.

 

[pr2-eugin]

Hello ghougher, Welcome to AWF

See if any of the records on the table you are Querying from contain a Null or no value.

 

[pbaldy]

Are there any Nulls in the DateDue field? You may need the Nz() function there.

 

[gdougher]

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 and AssignedTime (Required Training) and training records that do not (Developmental Training). But, the records I select in my query are just those that are Required Training and the AssignedTime and NotifyDate fields are all populated. Have I answered your question?

 

[gdougher]

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

 

[pbaldy]

Can you post the db here?

 

[pbaldy]

ps: Obviously Paul's think alike, one just types slower.

 

[gdougher]

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.

 

[pbaldy]

Easier for us if they're integrated into a single file, but no problem to post both.

http://www.access-programmers.co.uk/forums/showthread.php?t=140587

 

[gdougher]

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 back as his box is full. I am sorry, but thank you very much for taking your time and good efforts on my behalf.

 

[pbaldy]

Curious. Let's not give up quite yet. If you want, you can email it to me at:

pbaldy
gmail
com

and I'll post it here.