Default date is not entered in some records.

M

MKH

Hello,
I have an Access97 Data source table that I send INSERT SQL statements to
through an AccessXP front end. The Access97 Data table has a PostDate field
that has a Default value of Now(). There are several records that have no
date/time value in this field. The only way I am entering data is through the
SQL statements on the front end. Can anyone suggest what possible reasons for
this behavior is? I am wondering if I have a corrupt Data source table; or,
perhaps the version difference is having an affect on the table.
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Split form 0
Is this possible? 0
Copy previous record into form field 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Autonumber records inserted in gaps 0
How do I clear a form? 0
Some mail merge fields not pulling into document 2

Top