Append dates

[jk12]

Hi all. Having searched around I cannot seem to find what i'm after. I have a database which i hope to give users the option to run an append query which will copy certain pieces of information form one weeks to a another week.

Originally I thought about w/c + 7 which would give me a new week, but not all users were copying from one week to the next sometimes they would want to copy from one week to a date that was 2 or 3 weeks later.

What I can't find out is how to make the query append this date field to a date that is specified by the user.

Any ideas please so that I don't have to make some people angry with me.

 

[Dennisk]

In a query you can refer to a control not only in the criteria cell but also in the columnName cell. I have not tried this but I suspect you can refer to a value on a form in the update to cell as well. - Test it out.

Or

Instead of running a query build up your SQL statement in code where you will be able to substitute your date and then execute it. - plenty of examples on the forum.