none
My DefaultValue stopped working RRS feed

  • Question

  • I imported a spreadsheet into a table, and for a Date/Time field named "Created", I set a Default Value of "=Now()". This way, in Datasheet view, I was provided an editable timestamp on each record.

    Then I used the "Analyze Table" tool to split my table into several normalized tables. But now, in the new Items table, the same Default Value, fails to fill in the date.

    Image 1: Design of new Items table:

    Image 2: Datasheet View, New Record:

    Monday, March 30, 2020 12:41 AM

Answers

All replies