Updating a Table Query (Probably Easy) but Newbie

[zsalem]

Hi All.

I have a query where I am retrieving about 50K records with a field title ppe_date among many others like Name, Account Etc. This query retrieves 13 weeks of data, so at match there are 13 separate dates in the ppe_date field.

I have a static Table That has two columns, Wk# Column and ppe_date Column.

The Table A want updated looks like this.

Wk# ppe_date
Wk1
Wk2
Wk3
Wk4

I would like to run an update or instert into query retrieving on the distinct dates pp_date field in my query (13 dates) and updating table A above so that it looks like this. Dates should be sorted Ascending.

Wk# ppe_date
Wk1 9/23/2016
Wk2 9/16/2016
Wk3 9/9/2016
wk4 9/2/2016
etc
etc

If there is a better way, i am open arms!

Just starting to really dive into access.

Much Obliged!

 

[plog]

First, why do you need this data in a table? What's wrong with just using a query?

Second, can you post better sample data? Provide 2 sets:

A: Starting sample data from all relevant tables. Include table and field names and enough data to cover all cases.

B. Expected results of A. Show what you hope to end with when you start with A.