Part query, null query

D

Dreamstar_1961

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
 
D

Dreamstar_1961

Dreamstar_1961 said:
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
Click to expand...

I have a number of combo boxs just tryed to see if I can work it out, wiith
the combo boxes I can select records, from the other fields, but have noticed
that the rcords that don't have any thing in that field are not showing up,
 
Top