1 query 2 tables no idea

[Jim W]

Please help. I'm trying to write a query that updates a table based off data from 2 other tables. I do not know where to start. Table 1 holds the weeks Table 2 hold the data that I want sorted or broken down into the weeks from table 1.
Meaning Table 1 has 3 fields
WeekNumber , StartDate , EndDate
03 Week 45 , 11/10/03 , 11/16/03
03 Week 46 , 11/17/03 , 11/23/03
and so on to Week 52 at which it will change to 04 Week 1
Now the second table has the records that are entered by a Start Date so what I'm trying to do is have the Append query get the records or sort the records from table 2 and put them into the new table 3 based on their start date. So the data in the new table would look something like this
Week Number , Start Date , End Date , StartDate from second table , additional data from the second table.

Am I making any sense here. Can anyone help me out?

Jim

 

[uncle-lai]

Jim

I wonder if you really need a table to store the dates. I think you only need to store the start dates in you database, week number and end date are calculated values based on the start date. Check Help on "Format Function".

Peter