I'd like to thank everyone for their responses... After trying many
variations, I finally figured it out. By changing the single quotes back
to double quotes (normally some of the parameters to the where clause are
variables), I changed the double quotes around the first DatePart argument
t
age-
> From: S. William Schulz [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 05, 2001 3:06 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] Help with ODBC to Access query
>
>
> Hello,
>
> I'm trying to get the following query to work:
>
>
>Hello,
>
>I'm trying to get the following query to work:
>
> $query1 = 'SELECT COUNT(RunNumber) AS RunCount,
> DatePart("m", CallDate) AS MonNum
> FROM CallData
> WHERE (CallDate Between #1/1/00# AND #12/31/00#)
> AND Dri
Hello,
I'm trying to get the following query to work:
$query1 = 'SELECT COUNT(RunNumber) AS RunCount,
DatePart("m", CallDate) AS MonNum
FROM CallData
WHERE (CallDate Between #1/1/00# AND #12/31/00#)
AND Driver = 173
