RE: Access Date/Time Function, problem solved!

2000-05-15 Thread ldang {Lily Dang}
ECTED] Subject: RE: Access Date/Time Function It looks like Access thinks they're integers and is trying to divide 1 by zero indicating that they're not actually a date type(?) You might try the IsDate() function to verify that you have a data type of type date and then force it to date using

RE: Access Date/Time Function

2000-05-15 Thread Kelly Matthews
D] > 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 g

RE: Access Date/Time Function

2000-05-15 Thread William Adamsen
ateDiff("d", "#CreateODBCDate('1/1/00')#', '#CreateODBCDate('12/1/00')#')# -Original Message- From: ldang {Lily Dang} [mailto:[EMAIL PROTECTED]] Sent: Monday, May 15, 2000 1:19 PM To: '[EMAIL PROTECTED]' Subject: RE: Access Date/Time Function

RE: Access Date/Time Function

2000-05-15 Thread Marcus
> 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/

RE: Access Date/Time Function

2000-05-15 Thread ldang {Lily Dang}
Hi All, 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. Thanks, Lily -