I have a query - below - but it returns no values even though I see that they are on the table. I did a trim on the values coming in as well as the ones on the table. Can anyone see why I am getting no returns?
CurrInelSQL = "Select IneligibleUnits.* from IneligibleUnits where trim(DNumber) = ' " & dnum & " ' " _
& "And trim(BNumber) = ' " & bNum & " ' and trim(BNEnt) = ' " & bNnumEnt & " ' " _
& "And trim(UNumber) = ' " & unNum & " '; "