Modifying the Table Field into Records

[mkrylataya]

Hello folks,

Need help with the following.

I have a table that looks like this:

ProgramID	NewProgramDate	ApplicationDate
11111111	1/1/2016	5/10/2016

I need to convert it into the following table:

ProgramID	Event	Date
1111111	New Program	1/1/2016
111111	Application	5/10/2016

How do I do that?

[ranman256]

build a macro, with 2 append queries,
Q1 to add the NEW PROGRAM records,
Q2 to add the APPLICATIONs

[ssanfu]

Depends on if you have a table of "Events" linked to the first table above (sure wish you had used actual table names).

How do you know the date for Event "New Program" is "1/1/2016" ??
And Event date for "Application" is "5/10/2016"?