Generating report from fields chosen in a form

[kroenc17]

I lol'd. So, naturally now that I've finished this - I need to add another query criteria. Now the form also needs to have a date selector so, if desired, the report (which as a refresher shows weekly updates for ongoing projects) will only show entries from within a chosen time span. I've got my two text boxes, short date, show calendar all set up, I just don't know how to criteria-ize this within my query. The field it should filter is from "Date entered" in the "Weekly Status Call" table already in the query. I've tried a few ways but I don't know how to properly syntax it.

Something like:


[Forms]![NameOfForm]![Text19, 17]

I just don't know how to code it right. The two text boxes are Text19 and Text17.

Text17 is date from, and Text19 is date to.

Thanks again lol

[pbaldy]

It would look like:

Between [Forms]![NameOfForm]![Text17] And [Forms]![NameOfForm]![Text19]

[kroenc17]

Works..thanks, I figured there was an operator such as between that I was looking for just didn't know where to go. Was hoping I wouldn't need to make integers subtract 19-17 to get a integer date range and then plug that in there somewhere.. bla bla bla, I should probably be buying you lunch over paypal at this point. If I leave the fields blank then I get no data on my report - any way around this without adding a default value of Jan. 1 1900 for from and today as to? thanks again!

[pbaldy]

My step-daughter lives in NYC; I'll send her over for lunch.

Try this untested method:

Between Nz([Forms]![NameOfForm]![Text17], #1/1/1900#) And Nz([Forms]![NameOfForm]![Text19], #12/31/29#)

[kroenc17]

Thanks again - untested method a success first try.