Access Query - TechRepublic
General discussion
July 9, 2003 at 10:11 AM
choppit

Access Query

by choppit . Updated 22 years, 10 months ago

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?

This discussion is locked

All Comments