Question on sample database rptwithdates

[webmagic]

Hello all,
I am learning Access and am continuing to learn more and more and love it! I have gotten so much help on this forum from reading the posts and asking questions, I really thank everyone for there help. Just when I think I am getting going, I stumble though.

I am trying to make a report with date parameters. I looked at the sample database and can't figure out how the start and end date is being filtered. It doesn't use a query, so I am not sure how it is working. Can someone explain this to me?

Thank you in advance.

 

[pbaldy]

You haven't specified which sample database, but look at the code behind whatever button opens the report and see if it uses a wherecondition.

 

[webmagic]

rprtwithdates is the sample database.

 

[webmagic]

There is no where condition in the button-

 

[pbaldy]

Saying it's "the" sample database isn't very helpful, given that literally thousands have been posted. I guess I can't help you, since I don't know where it is.

Greetings from Reno though!

 

[webmagic]

I apologize-I have attached the database. I assume everyone is in my head!

Thank you for any help.

 

[pbaldy]

The form references are in the report's record source SQL.

 

[webmagic]

Still confused. How do I get to the record source sql? I understand where the label at the top comes in from the form, but cannot find any code for the dates. Sorry for being so new to this and not understanding.

Thanks again for your help and any further explanation.

 

[pbaldy]

In the properties of the report, look at the Record Source on the Data tab.

 

[webmagic]

It makes more sense now! Thank you very much!

 

[pbaldy]

No problem; us Reno-ites have to stick together!