Results 1 to 3 of 3

Thread: Table Query

  1. #1
    Join Date
    Mar 2004
    Posts
    36

    Unanswered: Table Query

    Hi

    I'm building a database (Access 97) to record process changes and want to be able to record the changes as 1.1; 1.2; 1.3; 1.4 etc.

    Within the design of the form I have tried to type these in the row source of a combo box but then when selecting the data I can only see 1 digit.

    Within the design of the table I have changed the field to 1 decimal place but this also doesn't work.

    Any ideas, is this possible?

    Thanks

  2. #2
    Join Date
    Nov 2003
    Posts
    267
    Is you Data Type in the table set to Single or Double? These type allow decimals. Interger is a whole number and doesn't

    S-

  3. #3
    Join Date
    Mar 2004
    Posts
    36
    Thanks - I've just changed to a double and it works!!

Posting Permissions

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