How to Export Data From table to Excel where Date = Blank

[Nikh]

Hi..,



I am unable to Export Data Into Excel from table using query where "Export_Date"=Blank. in Table

If Me.Option5 = -1 Then
            Set db = CurrentDb()
            Set Q = db.QueryDefs("CBDataEntryDump_Branchwise")
            Q.SQL = "Select * From CBDataEntryDump Where ([Branch_Name]= '" & TempVars!tempbranchname & "') AND ([Export]= '-1') AND Export_Date = NULL ;"
            Q.Close
            
            cbfilename = Environ("USERPROFILE") & "\Desktop\" & TempVars!tempbranchname & "_EquifaxReport_" & Format(Now(), "DDMMYYYY_HHMM") & ".xlsb"
            
            DoCmd.OutputTo acOutputQuery, "CBDataEntryDump_Branchwise", acFormatXLSB, cbfilename, False
            
            MsgBox " Data Exported to Desktop Sucessfully", vbInformation, "Data Export Successfully"
      
    End If

[ranman256]

Don't use SQL, use a query, then you wouldn't have the error.

you don't use = for null, it's :
field Is NULL.

booluean fields are numeric not string,
field = -1

[Nikh]

Don't use SQL, use a query, then you wouldn't have the error.

you don't use = for null, it's :
field Is NULL.

booluean fields are numeric not string,
field = -1

can you please share modified code as I am new and not understand how to code this..

Thanks in Advance.

Nikh