|
 |
access thread: Date search
Message #1 by gail711@g... on Wed, 16 Jan 2002 10:36:01
|
|
Can anyone tell me why this statement works for hours, but does not work
for the date criteria
totalhrsregistered = (DCount("[registration number]",
"testqrydateselect", _
"(format([time in],'hh')) = " & hour & _
" and format([date in],'dd/mm/yy') = " & day))
Message #2 by Lonnie Johnson <prodevmg@y...> on Wed, 16 Jan 2002 07:29:52 -0800 (PST)
|
|
--0-569403977-1011194992=:4723
Content-Type: text/plain; charset=us-ascii
Try using the pound sign like so...
totalhrsregistered = (DCount("[registration number]",
"testqrydateselect", _
"(format([time in],'hh')) = " & hour & _
" and format([date in],'dd/mm/yy') = #" & day & "#"))
Just a thought.
gail711@g... wrote:
Can anyone tell me why this statement works for hours, but does not work
for the date criteria
totalhrsregistered = (DCount("[registration number]",
"testqrydateselect", _
"(format([time in],'hh')) = " & hour & _
" and format([date in],'dd/mm/yy') = " & day))
Lonnie Johnson ljprodev@y...
ProDev, Builders of MS Access Databases
Let ProDev build your next MS Access database application.
http://www.galaxymall.com/software/PRODEV
Get paid cash every time you receive email!
Sign up FREE at: http://www.MintMail.com/?m=975303
---------------------------------
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail.
|
|
|
View Cart
