strSQL help????

Results 1 to 2 of 2

Thread: strSQL help????

  1. #1
    Join Date
    Dec 1969

    Default strSQL help????

    &nbsp;<BR><BR>Can some one tell me why this query string would not return a record while it does work fine in Access query builder.<BR><BR> strSQL = "SELECT [tblRates].[Rate], [tblRoomType].[RoomType], [tblRoomType].[RoomTypeDesc]" &_<BR> "FROM ((tblHolidayPeriod INNER JOIN tblRates ON [tblHolidayPeriod].[holidayPeriodID]=[tblRates].[holidayPeriodID])" &_<BR> "INNER JOIN tblRoomSize ON [tblRates].[roomSizeID]=[tblRoomSize].[roomSizeID]) " &_<BR> "INNER JOIN tblRoomType ON [tblRates].[roomTypeID]=[tblRoomType].[roomTypeID] " &_<BR> "WHERE ((([tblHolidayPeriod].[startDate])&#060;=CDate(3/22/2003)) And (([tblHolidayPeriod].[endDate])&#062;=CDate(3/22/2003))) " &_<BR> "AND [tblRoomSize].[RoomSizeID]=1 "<BR><BR>Thanks<BR>Sharjeel<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: strSQL help????

    Try without the brackets:<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts