Update more queries with the same parameters

[Christian1977]

Dear All,



I have a db with a lot of queries and I need to update them every week with a progressive weekly number.
Now I update them manually.

Es.: Next week, will be the week number 26, so in the query field "Week" I change it from 25 to 26. Next week I'll change it from 26 to 27 and so on every week.

Could you help me? Thanks

[rzw0wr]

look into DateDiff(() function.

http://www.techonthenet.com/access/f...e/datediff.php

Dale

[Christian1977]

Thanks rzw0wr,

maybe I hadn't explain very well my problem.
I'd like insert a number of the new week in a query or in other elements one time and update all queries, like a variable. Thans

[rzw0wr]

I understood and I gave you an answer.

Datediff() should solve your problem.

Datediff("ww",#1/1/2013#,Date()) should return the week number of this week.

Dale

[Christian1977]

Great Job!

Problem Solved! Thanks