Like [forms]![Main]![Text49]
but its not working like regular Ms Access query, it keeps giving me (Your entry cannot be converted to a valid date time value), can you help me with this query please?
This is the code for the query
Expand|Select|Wrap|Line Numbers
- INSERT INTO dbo.AccTDailyT
- (No, AccountNo, AccountName, AccountName2, Balance, TransDate)
- SELECT No, AccountNo, AccountName, AccountName2, Balance, TransDate
- FROM dbo.Acct_DataT
- ORDER BY No