Minggu, 07 Februari 2016

[MS_AccessPros] InputBox in Expression Builder in a query

 

I am looking for a way have a query to ask a user enter a date, use the date that they enter and output the date they enter plus a fixed amount. i.e. Expression field ProductionDate       [Enter Date of Production], they enter 2/7/16, and have the expression add 365 days to output 2/7/17.

I came across the function for InputBox, and have successfully had it output   [Enter Date of Production], but have been unable to have accept the input, and output the expression ProductionDate + 365.


Any Help would be greatly appreciated.

Thanks so much,

Katie

__._,_.___

Posted by: katie.trejo@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar