By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,946 Members | 1,701 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,946 IT Pros & Developers. It's quick & easy.

Group By DateValue fails in Access 2K

P: n/a
J
In Access 2000 the following query works:

Select DateValue(EnteredTime)
From tblMyTable

But adding the following clause fails:

Group by DateValue(EnteredTime)

The error is:

Data type mismatch in criteria expression. A similar query appears to work
ok in Access 2003.

Thx for your help.
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Mon, 26 Jul 2004 00:03:31 -0500, "J" <so*********@nobody.com> wrote:
In Access 2000 the following query works:

Select DateValue(EnteredTime)
From tblMyTable

But adding the following clause fails:

Group by DateValue(EnteredTime)

The error is:

Data type mismatch in criteria expression. A similar query appears to work
ok in Access 2003.

Thx for your help.


What is DateValue? Do you mean CDate?
Nov 13 '05 #2

P: n/a
J

What is DateValue? Do you mean CDate?


It's an Access function that's apparently commonly used in order to retrieve
the date only from a datetime field.
Nov 13 '05 #3

P: n/a
On Mon, 26 Jul 2004 10:52:42 -0500, "J" <so*********@nobody.com> wrote:

What is DateValue? Do you mean CDate?


It's an Access function that's apparently commonly used in order to retrieve
the date only from a datetime field.


I guess I've never known about that. I've always used
CDate(Int(<datevalue>)). Perhaps, that will work in your case, if DateValue
will not.
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.