Make Table using Form Value

[Skootr]

Hello all,
I am attempting to make a table using a Form to populate 2 of the 9 fields. The other 7 fields are all populated as title:"data" for what I need for the first record. Those all work fine. The other two fields I have are..
Transaction Date:[Forms]![Start Form]![TX Date]


Post Date:[Forms]![Start Form]![Post Date]

The problem I am having is that when run, all the fields get populated just fine except the date fields. Those end up null.

What am I missing?

SQL below

SELECT "Header" AS Detail, "GJ" AS Line, "USD" AS Account, [Forms]![Start Form]![TX Date] AS Division, [Forms]![Start Form]![Post Date] AS Branch, "" AS Center, "" AS Debit, "" AS Credit, "" AS Adjustment INTO [export]

I'm using this to prep a bunch of data for export as CSV, and the first line needs to have the data I'm setting in the make table query. All other data will be selected via query and appended to this one from existing tables.

[June7]

Had to go to Firefox to see the SQL.

[boblarson]

Can't see your SQL.

[Skootr]

SELECT "Header" AS Detail, "GJ" AS Line, "USD" AS Account,
 [Forms]![Start Form]![TX Date] AS Division,
 [Forms]![Start Form]![Post Date] AS Branch,
 "" AS Center, "" AS Debit, "" AS Credit, "" AS Adjustment
 INTO [Coast to Coast export];

Sorry, copy and paste out of access (from design to SQL view) didn't seem to work well with the forums.

[boblarson]

The SQL you posted works fine for me. But you have to move from the one Text Box to the other to let it update. If you just type in the one but don't move out of it, there will be no value to use.