Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with data type date?????????????

Status
Not open for further replies.
Parula

Parula

Programmer
May 10, 2001
18
US
I have a table that has a field that contains a date. I would like to be able to automatically have the date filled once I use that field in a query. Is that a way for me do that?

Thank you

Parula
 
Sort by date Sort by votes
In design go to the properties for the field, in default view
=Now()
-Smack
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
822
strongm
strongm
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
544
mikrom
mikrom
combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
1K
combo
combo
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
764
dhookom
dhookom
monkeysee
  • Locked
  • Question
Max Date Qry 1
Replies
3
Views
830
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top