Crazy compatability question for an old db odbc?

[Ivan]

I am working on a project for a company that uses an old ROI ODBC database.
Honestly, I do not know much about it, but I can get more info.
They are using ODBC interfaces to retrieve stored data, but they have found
no practical solutions for importing data from access to the old system.

For example: They only Criteria the old system allows or "Understands" for
a date specific orders query is using #3/15/05#. It does not understand any
codes for daily auto updates. Dates must be changed manualy to run a query
for a report.

Any thoughts?

Sorry in advance if the question is too vague!

 

[John Nurick]

Have you experimented with using the Format() function in calculated
fields in queries?

E.g.
fDate: "#" & Format([TheDate], "m/d/yy") & "#"