I am using the Crystal VB control in VB 6. I am running a report from an
Access query and need to specify a date range for that report but cant
figure out how to make it work. What am I doing wrong?

This is the code I'm using:

ReportInternal.SQLQuery = "SELECT show.ShowDate, venue.VenueName,
venue.VenueCapacity, venue.VenueCity, venue.VenueState,
promoter.PromoterName, show.ShowRadioPartner, promoter.PromoterContact,
promoter.PromoterPhone, show.ShowGurantee, show.ShowDeposit FROM promoter
INNER JOIN (venue INNER JOIN show ON venue.VenueID = show.ShowVenue) ON
promoter.PromoterID = show.ShowPromoter WHERE show.ShowDate <= #10/10/2000#
"

ReportInternal.Action = 1