Are you putting single quotes around the dates in the WHERE CLAUSE?
If so try removing them it shouldnt need quotes I have run into this before.
Kelly
> -----Original Message-----
> From: Marcus [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, May 15, 2000 5:04 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Access Date/Time Function
>
> > I am using Access 2000. When I try to do search for the date range say,
> > from '1/1/00' to '12/1/00'. Access gives me an error saying that it's
> not
> > divisible by 00. Any help would be greatly appreciated.
>
> thats because the computer is trying to do the math you have put in front
> of
> it.
>
> 1/1/00 is 1 divided by 1 divided by 00... can't divide by 0 so it errors.
>
> Marcus
>
> --------------------------------------------------------------------------
> ----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
