I am having a problem getting this query to work. Database type is Access.
<cfquery name="getreport" datasource="FSDB">
SELECT DISTINCTROW (Right(Left([BODY1],13),8)) AS [NewOrder], Min(ITEM_HISTORY.DATE) AS [TranDate] INTO [BookingsTable]
FROM ITEM_HISTORY WHERE (((ITEM_HISTORY.TRANS_ID) Like...