I have a table called MonDaily that contains a field named Orders. I also have tables for Tuesday, Wednesday, Thursday, Friday, and Saturday with the same fields. These tables all have a relationship of the 'WeekNo' field which is also set as the primary key. I have a table called Weekly with the same field "Orders". I need to be able to enter a WeekNo and have the program pull the data from the order fields from the daily tables just for that week number and insert them into the weekly table.

Can someone provide details on how to accomplish this?

Thanks.

You don't need tables for each day of the week, just one table,which includes the date of the order. The day/month/year etc can be extracted from that date. Have a look at some of the sample dbs supplied with Access, there is an Orders entry db.