Here is the SQL statement that will return the results you want. From your example, it looks like you have your ODBC data source set to Standard Descriptions, so I've used that methodology. I copied this out of an actual query I use, so I can confirm it works. Copy it into the connection string box of the Excel Query:
APInfo.Bank_Account as "Bank Account",
APInfo.`Check` as "Check No",
APInfo.Check_Date as "Check Date",
APInfo.Amount as "Amount",
APInfo.Vendor as "Vendor"
FROM APM_MASTER__CHECK APInfo
WHERE (APInfo.Check_Date>=?) AND (APInfo.Check_Date<=?)
Hope that helps.
Brier Hill Associates, LLC
Home of the Connection Café.
100 Village Blvd., Suite 200, Princeton, NJ 08540Phone: 609-452-8000 | 888-421-9996 | Fax: 609-452-0474 | email@example.com