Syntax error on VB Select Where Clause

[FrustratedAlso]

SalStrSql = "Select Sales.[VendorID], Sales.[vInvoiceNumber], Sales.[Consigned], Sales.[Quantity], Sales.[TagPrice], Sales.[DiscountPercent], Sales.[SaleDate] from Sales WHERE (Sales.[VendorID] = """ & dNbr & """ AND Sales.[vInvoiceNumber] Is Null AND (Sales.[SaleDate] >= # " & Format(PeriodStart, "M/D/YYYY") & "# And Sales.[SaleDate] <= #" & Format(PeriodEnd, "M/D/YYYY") & "#))"""

Gives syntax error on this portion

(Sales.[VendorID] = """ & dNbr & """ AND Sales.[vInvoiceNumber] Is Null AND (Sales.[SaleDate] >= # " & Format(PeriodStart, "M/D/YYYY") & "# And Sales.[SaleDate] <= #" & Format(PeriodEnd, "M/D/YYYY") & "#))"""

Help! I've stared at it so much I'm going blind

[JoeM]

My recommendation is to build an example of this query in Query Builder, and make sure you get it working properly. Then switch to SQL View and Copy and Paste the SQL code out to a text file.

Then, where you have built the SQL code construction in VBA, return the code to a Message Box before running it. Then compare those results to the copy of the SQL code you have in your Text file, and locate the differences. Basically, your goal is to modify your VBA code so that what is returned in your Message Box matches the working code in your Text file. Once you do accomplish that, your code should run without errors.

[June7]

The last triple quote should be a single.

[FrustratedAlso]

Thanks, I took a nap and figured it out