parameter query by form accepting null values

[trixxnixon]

long time no see,

what would be the correct addition to the query expression below, so the query would pull all values when the fields on the form are left blank.

Between [Forms]![frm_Reporting]![begin] And [Forms]![frm_Reporting]![end]

[NeoPa]

Hi Trixx.

Something like :

Between Nz([Forms]![frm_Reporting]![begin],#1/1/1900#)
    And Nz([Forms]![frm_Reporting]![end],#12/31/9999#)

That's for date fields of course. The concept is similar for other types though, of course.

[trixxnixon]

you are too awesome.
do you only do MS access questions on this board?

[NeoPa]

My main job is a Networks Administrator, so I sometimes visit that forum and the Windows forum, but I don't often run short of work to do in Access. That, and administrative duties take up quite a lot of my time too.