Hi all, I wrote the blew code to create report based on "age" and "career" , the code is working right when the text boxes is filled but it gives blank report (without any records) when Text57 and Text74 is empty and I want to consider all ages when text boxes of age is empty, for ths reason I used Nz function in text boxes but I guess it's wrong :
Can someone give me a solution?
thanks in advanced.
Code:
DoCmd.OpenReport "rpt_one", acViewPreview, , "[T_age] Between '" & Nz(Me.Text74, "*") & "' And '" & Nz(Me.Text57, "*") & "' and [T_career] LIKE '" & Nz(Me.Combo12, "*") & "'"
Can someone give me a solution?
thanks in advanced.