sSQL1 = "SELECT [Customer Info].[First Name], [Customer Info].[Last Name], [Customer Info].Address, [Customer Info].City, [Customer Info].[Phone Number], Appointments.Date, Appointments.Time FROM Appointments INNER JOIN [Customer Info] ON Appointments.[Cust ID Number] = [Customer Info].[Cust ID Number] BETWEEN #" & sDateFrom & "# AND #" & sDateTo & "#" '& "ORDER BY Appointments.Date, Appointments.Time"


says BETWEEN operator wiothout AND ? oh got the base sql from access a friend showed me how to cheat. i just create the query in access then modify it! ha ha duh on my part!?