Hello all;
I have tried every combination I could think of, but I'm still stuck. Can anyone see any issues with the following code? I also tried placing # in several different places as tests, but still the same error.
strSQL2 = "SELECT * " & _
"FROM tbl_WorkOrderTickets_Converted " & _
"WHERE (((tbl_WorkOrderTickets_Converted.dDateTicketAssig ned) = (" & [Forms]![frm_AM_LoadOtherTickets].[tb_dDate] & "" * "" & ")" & _
"AND IsNull([dDateTicketCompleted]);"
dDateTicketAssigned is formatted as General date
tb_dDate is formatted as short date on form
dDateTicketCompleted is formatted as General date
In short, the intent is to return a dataset based on date, from the users input on the form as the variable.
Thanks...