Jim-
If you want to append a record with today's date, simply run the INSERT query but leave out the DateOfProcess field - it will default to today in any new record.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jan 9, 2015, at 4:17 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hello all,
I am trying to append a record into a table based on the date in the record. the table name is tblCurrentEmployeesAnalysis where the field DateOfProcess has a default value of Date(). But I am blank on a Friday on how to do this. Any help would be appreciative.
Thank You
Jim Wagner
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (7) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar