ODBC link

[deb]

I have an Access database with a ODBC link to a Lotus Notes Database.

The link creates all fields in the table as Text. Even the date fields.

I have created a "Make Table" and then changed the fields to Date, but when I run the "make table" again it changes the fields back to Text.

I have tried creating queries and setting property to date format.

Nothing works.

Please help with this!!!

 

[Russell Hauf]

I would have to see the query. Is the date blank in the table that you made?

 

[deb]

Please disregard my last note...

My finger went crazy and typed the wrong thing.


It works beautifully!!!!