Timestamp through query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I have built an Append Query to input product details ready to be sent to
a manufacturer. I want the record to include the Date/Time the order was
sent.
Is there anyway I could put a timestamp onto a field so that I will be able
to know when the Order was sent?

NB I have tried Default Value in the table itself already and it's not what
I want, it must be the current Date/Time pf the order!

Thanks
 
Buckaroo,
I'm assuming that the date you run the Append query equals the date you send...

An Append query can append the current Date to the table being appended to.
Your table being appended to will have to have a field to receive that value (ex.
DateSent)
Ex...
Field AppendThisDate : Date()
AppendTo DateSent
 
You must log in or register to reply here.

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

timestamp 3
Formatting Question 2
SQL Timestamp field for Access use 28
Parsing a Timestamp 5
timestamp handle 5
How to get needed records for report 18
Insert or update record with vba and ado 2
Comparing records by year in a report 2

Back
Top