How to convert access SQL to SQL in iSQlW

Hello all,

I have a query that works in access, but I would like to run it in iSQLW. I
have a few syntax errors. can anyone help?

SELECT SHIP_ZONE AS [Pool Point], Count(*) AS Total
FROM (SELECT DISTINCT ship_zone, nest_to_cont FROM VIAWARE_WCS_TO_VIA_T
WHERE TRANS_STT='01' And (((DTIMECRE) Between #10/27/2008# And #11/2/2008#)))
AS x
GROUP BY SHIP_ZONE
ORDER BY Count(*) DESC;

Mark,

Access SQL does not always convert readily to TSQL. Different dialects,
different solutions. The only way to get a good translation is to do it
yourself.

However, in the current piece of code, if you replace the # around the dates
with single quotes, '10/27/2008' And '11/2/2008', it will parse correctly
and it looks like it will run correctly.

By the way, your date format is locale specific. A date that will be
recognized by any locale (or, in SQL Server: language) is YYYYMMDD. Just in
case that matters to you.

RLF

"Mark" wrote in message

> Hello all,
>
> I have a query that works in access, but I would like to run it in iSQLW.
> I
> have a few syntax errors. can anyone help?
>
> SELECT SHIP_ZONE AS [Pool Point], Count(*) AS Total
> FROM (SELECT DISTINCT ship_zone, nest_to_cont FROM VIAWARE_WCS_TO_VIA_T
> WHERE TRANS_STT='01' And (((DTIMECRE) Between #10/27/2008# And
> #11/2/2008#)))
> AS x
> GROUP BY SHIP_ZONE
> ORDER BY Count(*) DESC;
>