format field in a make table query

[deb]

I am using a make table query (Access2000) to create a table via ODBC to Lotus Notes.

The field in LN is in decimal format, however when I import via make table, it rounds it to a whole number. How can I get the data to import as a decimal?

Thanks in advance...

 

[ddeldeb]

Notes can be awfull picky about what you send it. You may already have this, but on the Lotus web site the have a ODBC Lotus SQL interface you can install on your PC to make calls to Notes DB's. I dont have the name of the Exe at home but I can check at work tomorrow and post it. This may give you more controll over the data transfers.

 

[ddeldeb]

Go to the Lotus web site and search for NotesSQL 3.02