S
spcscooter via AccessMonster.com
I am really not sure how I want to say this but I will do my best.
I have a query that is based off of a form with the following fields.
Employee ID, Last Name, First Name, Fulfillment
I want to add new fields in a Query and name them Certification Date and
Expiration Date.
The Certification Date needs to be manually entered and the Expiration Date
needs to added automatically. I have the Expiration Date working but I can't
seem to get the Certification Date to work the way I want it. Every time I
enter the header info in design view (Certification Date: 0 ) it comes up
with a date in the 1800's. I know that Certification Date: 0 is wrong but I
can't remember what to do or if it will even work the way I want. All I want
is the column to be named Certification Date and some one to be able to
manually enter the date of certification.
Anything you can help with is greatly apreciated.
Thanks,
Scot
I have a query that is based off of a form with the following fields.
Employee ID, Last Name, First Name, Fulfillment
I want to add new fields in a Query and name them Certification Date and
Expiration Date.
The Certification Date needs to be manually entered and the Expiration Date
needs to added automatically. I have the Expiration Date working but I can't
seem to get the Certification Date to work the way I want it. Every time I
enter the header info in design view (Certification Date: 0 ) it comes up
with a date in the 1800's. I know that Certification Date: 0 is wrong but I
can't remember what to do or if it will even work the way I want. All I want
is the column to be named Certification Date and some one to be able to
manually enter the date of certification.
Anything you can help with is greatly apreciated.
Thanks,
Scot