Hard to say without knowing the data type and function of these columns.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Mike" wrote:
Dave TY VERY MUCH

To use this for what I need all I should need to do is Substitute the
select
from and where. The other thing I m not sure of would be the
(InvAdj.REC_TYPE)=10)) OR (((InvAdj.TIME_STAMP)=15)) ORDER BY
InvAdj.TIME_STAMP" _

When in access I had to pass to REC_TYPE=10 Or 15 in the time stamp field
to
get the right info when closed and went back into the 10 stayed in the
time
stamp field and the 15 was in the REC_TYPE field

IS This going to be a problem
But ill try and see what happens