Last post Nov 18, 2010 12:09 PM by Phillip J
Nov 18, 2010 12:02 PM|Phillip J|LINK
I have an Access 2010 DB that I have a table of RAW data in. In my scenero when table 'a' has been populated all the rows with the updatedate of Now() get moved to another table... the SQL is like this...
INSERT INTO Transaction_Master ( post_tran_cust_id, message_type, tran_type, extended_tran_type )
SELECT RAW_Transaction_Data.post_tran_cust_id, RAW_Transaction_Data.message_type, RAW_Transaction_Data.tran_type, RAW_Transaction_Data.extended_tran_type
As you can see it is a very simple query but it does NOT return any rows. There are actually 404 rows with todays date in teh Append_Date column.
I am stumped as to why it does not return rows?
Nov 18, 2010 12:09 PM|Phillip J|LINK
Okay solution found...