I have a query design that i take fields from the users table. I am trying to make a copy of that users table but I want to a new column not in the original table "users" which is the current date and time. How to add that in the query design?
Advanced Beginner
Windows 11 
Access 2016
I have a query design that i take fields from the users table. I am trying to make a copy of that users table but I want to a new column not in the original table "users" which is the current date and time. How to add that in the query design?
VIP
Windows 10 Access 2010 32bit
In cell on Field row enter:
CurDte: Date()
or
CurDtTm: Now()
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
VIP
Windows 11 Access 2019
Why not just add that field to the User table?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
DateAdd in Query Criteria to display a date in a field 2 days prior to the date in another field
How to compare an Access date field to a SQL Server date field
Posting Permissions
Reply With Quote