Except in very special circumstances, you SHOULD NOT add the calculated
value to the table. If you can calculate it on a form, you can calculate it
in a query or report just as well.
I just need to write a query based on a date and add one year to the
parameter. For example if the customer adds the date 01/01/05 I wish the
query to return records for 01/01/06. Any ideas?
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.