how to add sequential dates with ref nr with append query

I want to populate a table with field:date and field ref nr.(7 fixed ProductID's)

But only weekday and to 3 years from now. (every weekday)





Example



field:ID | date | fixed.ref.nr

--------------------------------

1 | 7/4/2015 | 1001

2 | 8/4/2015 | 1002

3 | 9/4/2015 | 1003

4 | 10/4/2015 | 1004

5 | 13/4/2015 | 1005

6 | 14/4/2015 | 1006

7 | 15/4/2015 | 1007

8 | 16/4/2015 | 1001

9 | 17/4/2015 | 1002

10 | 18/4/2015 | 1003

.... (ID field is autonumber field and not important..)



If anyone can help me out how to do this with a append query or code?



Thank you in advance!



Bart from Belgium

how to add sequential dates with ref nr with append query