« Help! Using a count expression with IF statements in access!?
Microsoft access? »

How can you get MS Access to add the date to a date field automatically?

How can you get MS access to add the date to a date field automatically? I want it so when I put data into the table i want it so my date field automatically puts the date it was entered into the date field.

1. Go into Design Mode on the table.

2. Create a new field in that table.

3. Give it a data type of Date/Time

4. On the general properties of that field (below) find the Default Value entry and add this:
Now()

That’s it, each time a row is written to that table it will be time stamped with the date and time of day.

HTH,
aaron

This entry was posted on Wednesday, February 17th, 2010 at 12:02 pm and is filed under ms access. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “How can you get MS Access to add the date to a date field automatically?”

  1. Germann A Says:
    February 17th, 2010 at 5:52 pm

    http://www.google.ie/search?q=sql+date+functions&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a
    References :

  2. Aaron Says:
    February 17th, 2010 at 6:09 pm

    1. Go into Design Mode on the table.

    2. Create a new field in that table.

    3. Give it a data type of Date/Time

    4. On the general properties of that field (below) find the Default Value entry and add this:
    Now()

    That’s it, each time a row is written to that table it will be time stamped with the date and time of day.

    HTH,
    aaron
    References :

Leave a Reply