G
Guest
been trying to work out how to do this I've worked out the part query, but
trying to work out the null section, this query is running from a form, with
a text box,
What I got at the moment is " Like "*" & [Forms]![CustomerQry_frm]![OrderNo]
& "*" ", I got this so if all the number is in or part it will return the
record, the problem is some of them do not have that order number as yet, so
they are blank, the full query uses null command for if it's blank they are
not in,
this is the other part for the rest of the form
" Forms![CustomerQry_frm]![Customer_frm] Or Like
Forms![CustomerQry_frm]![Customer_frm] Is Null " hope you can follow what I'm
trying to find out
trying to work out the null section, this query is running from a form, with
a text box,
What I got at the moment is " Like "*" & [Forms]![CustomerQry_frm]![OrderNo]
& "*" ", I got this so if all the number is in or part it will return the
record, the problem is some of them do not have that order number as yet, so
they are blank, the full query uses null command for if it's blank they are
not in,
this is the other part for the rest of the form
" Forms![CustomerQry_frm]![Customer_frm] Or Like
Forms![CustomerQry_frm]![Customer_frm] Is Null " hope you can follow what I'm
trying to find out