Hi, I'm new to Access,
I am currently working on building a form to with combo boxes, etc, for users to enter or pull down a number.
in my query, I'm not sure what to do, when a user does not or leave blank... here is what it looks like ...
Lets say I'm querying by State and net income..
if state is pick "CA"
and income is left out at zero, i want the results to still show.
Bewteen Nz([StartNo],0) And Nz([EndNumber],100000000)
keeps saying error !
can u guys help..thanks
I am currently working on building a form to with combo boxes, etc, for users to enter or pull down a number.
in my query, I'm not sure what to do, when a user does not or leave blank... here is what it looks like ...
Lets say I'm querying by State and net income..
if state is pick "CA"
and income is left out at zero, i want the results to still show.
Bewteen Nz([StartNo],0) And Nz([EndNumber],100000000)
keeps saying error !
can u guys help..thanks