I built a query using the designer then opened up SQL View and grabbed this syntax, as I thought it would be the correct VBA syntax. However, the VBE gives me an error of "Syntax Error" - what do I need to change in this syntax so that it is valid for VBA?
Code:strSQL = "Select [Emp Name], [Emp Phone], EmpDailySalesQty, ROUND(EmpDailySalePrice) As [Average Price], Format([Sale Date],"mm/dd/yyyy/") As [Sales Date] FROM SalesLog" Set qdf = CurrentDb.CreateQueryDef("Sales Log", strSQL)