new sql problem but getting better [Archive]

Bam_BamIR

Aug 24th, 2000, 11:18 AM

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

Aug 24th, 2000, 11:25 AM

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".