Advertisement

03.31.2005 at 02:26PM PST, ID: 21372155
[x]
Attachment Details

data type mismatch in Access

Asked by johnnywong71 in Microsoft Access Database

Tags: type, mismatch, access, data

I try to pull out data from a table(a linked table) .
I want to get all the date  from the al1 table where the date is after today.
Table al1 contains a field "datefield" which text format likes "23-May-2005"

If I run this query:
SELECT CDate(al1.datefield) AS Expr1
FROM al1;
,it worked fine

But I run this query:
SELECT CDate(al1.datefield) AS Expr1
FROM al1
WHERE (((CDate(al1.datefield))>Date()));
, it did day "Data type mismatch in criterial expression"

How could I fix it?

Thanks!
Start Free Trial
[+][-]03.31.2005 at 02:30PM PST, ID: 13676390

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]03.31.2005 at 02:51PM PST, ID: 13676594

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]03.31.2005 at 02:57PM PST, ID: 13676642

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]03.31.2005 at 09:51PM PST, ID: 13678456

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]04.01.2005 at 08:24AM PST, ID: 13682098

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.01.2005 at 08:26AM PST, ID: 13682116

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]04.01.2005 at 08:30AM PST, ID: 13682152

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.01.2005 at 08:31AM PST, ID: 13682169

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Access Database
Tags: type, mismatch, access, data
Sign Up Now!
Solution Provided By: shanesuebsahakarn
Participating Experts: 4
Solution Grade: A
 
 
[+][-]04.01.2005 at 08:38AM PST, ID: 13682223

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32