Code: Select all
SELECT Trades.Tradedate, Day([tradedate]) AS [Day], Month([tradedate]) AS [Month], Year([tradedate]) AS [Year], Trades.Symbol, Trades.ContractMonth, Trades.Quantity, Trades.ActionID, Trades.ActionName, Trades.RawP, Trades.Price, Trades.Commission, Trades.Fees, Trades.Amount, Trades.Profit, Trades.OrderNum, Trades.Notes
FROM Trades
WHERE (((Day([tradedate]))=31) AND ((Month([tradedate]))=5) AND ((Year([tradedate]))=23))
ORDER BY Trades.Tradedate;