problem running sql statement in access within win 98 platform

M

Martin

I am trying to extract data from my access database using the following
statement. It works when running on a windows 2000/XP machine but does not
run on a windows 98 machine.

Any help on why not would be appreciated.

Select Stockitems.*, SpecialOffers.Price from StockItems left join
SpecialOffers on (StockItems.Itnbr = SpecialOffers.Itnbr and #02/25/05# <=
DateTo and #02/28/05# >= DateFrom )
where (StockItems.Itnbr like '*acc*' or Stockitems.Description like '*acc*')
order by Stockitems.Itnbr;

regards,
martin
 
Top