Joining Queries

[Gabriel Tan]

For automating my expiry date using DateAdd so that i can
reference it to the period of warrenty. but i have 3
queries doing this as there are 3 periods can i interjoin
the 3 queries to show all my details ? and also how do i
auto prompt whenever my date meets with now(as in todays
date) and if i could could i set my auto prompt msg to
display the companies name?

 

[GVaught]

don't use Now() as this incorporates the time with the date. You will be
better off using Date()

If you need to calculate the expiration date for a warranty, it would be
easiest if you have a field that captures the warranty period in days or in
months. Then in your calculation you use the DateAdd to add #ofdays or #of
months to get the expiration date.

Example: WarrantyPeriod: 30 (days). Calculated field: Warranty
ExpirationateAdd("d", [WarrantyPeriod], Date())
WarrantyPeriod:3 (months). Calculated field: Warranty
ExpirationateAdd("n", [WarrantyPeriod], Date())

Note: These calculations are off the top of my head and have not been tested
for correct syntax and/or results.