Access sql query problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to extract data from my data 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 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
 
Hi,

Make a saved query:

SELECT *
FROM StockItems
WHERE #02/25/05# <= DateTo
and #02/28/05# >= DateFrom
and (Itnbr like '*acc*' or Description like '*acc*')




then, use that saved query, say q1, and:

SELECT q1.*, SpecialOffers.Price
FROM q1 left join SpecialOffers
on q1.Itnbr = SpecialOffers.Itnbr
ORDER by q1.Itnbr;




Hoping it may help,
Vanderghast, Access MVP
 
Back
Top