G
Guest
Happy New Year
I'm setting up a form based parameter query that uses drop down boxes to
search different fields. One of the parameters I want to search for is null
fields (not zero length strings since the field in the table was set up not
to accept those).
Can someone tell me what expression to use in the criteria field of the
query to retrieve null values. Since the query receives the parameter from
the form I know it's something like
forms!formname!controlname.....(but then what?)
Thanks for any help
I'm setting up a form based parameter query that uses drop down boxes to
search different fields. One of the parameters I want to search for is null
fields (not zero length strings since the field in the table was set up not
to accept those).
Can someone tell me what expression to use in the criteria field of the
query to retrieve null values. Since the query receives the parameter from
the form I know it's something like
forms!formname!controlname.....(but then what?)
Thanks for any help