I have a table (named "Table1") with a field (named "Count") to enter figures on a daily basis. I also have a table (named "Table2") with fields (named "Mon","Tue","Wed","Thu","Fri")for weekly figures. This is an example of what I need.

Grab figure from Table1.Count and place it in Table2.Mon, Tue, Wed, Thu, or Fri depending on the date. I also have a table with each day of the current year, the week number, and day # of the week thinking that this might be something to reference for specific weeks and days.

What would be the best way of doing this?

Thanks.

It is better to not do it at all. If Table1 contains the date that Count was entered, you can use a crosstab to display Table1 in a format similar to that of Table2.