Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003

    Unanswered: format field in a make table query

    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...

  2. #2
    Join Date
    Dec 2003

    Re: format field in a make table query

    I have no experience with LN, but would it be possible to link an existing, empty Access table with the field types you need, to your LN data and use an append query?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts