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
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.Code: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]