new sql problem but getting better

[Bam_BamIR]

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!?

[JHausmann]

Looks like you're you need a date variable (field) in the part of the statement that reads [Customer Info].[Cust ID Number] BETWEEN . That and an "and" or "where".

[Bam_BamIR]

duh i'm a sleep again tnx. getting worse?