Joining Queries

  • Thread starter Thread starter Gabriel Tan
  • Start date Start date
G

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?
 
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
Expiration:DateAdd("d", [WarrantyPeriod], Date())
WarrantyPeriod:3 (months). Calculated field: Warranty
Expiration:DateAdd("n", [WarrantyPeriod], Date())

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