date time format???

[twospoons]

hello, i have a linked table to an oracle datebase with a time stamp as the primary key, TXN_DATE. I am trying to write a query in access that selects the records where

TXN_DATE >= [Date_Range].[Start_Date] AND
TXN_DATE <= [Date_Range].[End_Date]

Date_Range is a local table inside of access that stores a date/time value entered by the user. when i try to run this i get an error (i'm guess from oracle)?

how can i format these two dates the same so that this query will work?

 

[PHV]

Any chance you could post the whole error message(s) ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886