I have created an access query that gets its paramenters from controls on a form. This works fine unless any of the controls are left blank in which case no records are returned. How can I make the query return all record for a blank field (i.e. what value should be returned to the query parameter for that field, I’ve tried “” and *.
Even better, how can I make the query read its parameters from VBA variables?