Between Dates

[jerry28ph]

Hi to all,

I've been doing a report using "Between" dates and it works. The only thing that I want to ask from you guys is how can I put those dates (e.g. Start: 11/1/2008 to End: 11/30/2008) on the reports. Once I run the report it will ask for "Parameter Values" for both fields (start and end dates). How can I use those fields to show on my report/print out. Please help me.
Thank you guys for all your help and I really appreciated it.

More power to all of you.

Regards,
Jerry

 

[namliam]

You cannot... unless...
1)
You add the parameters to the query as dummy columns

2)
Use a "search form" (search the forum for some samples) to enter the dates

I recomend 2.

Good luck!

 

[jerry28ph]

hi namliam,

thanks for a quick response. anyways, would you mind if i ask how can i use your first option? Yeah I had a query for this report, I mean what criteria should i add on my query? I know what dummy data is, but how can i put it on my query. I really appreciate your help on this.

Thanks a million.

 

[Singh400]

Expanding on namliam first option. In query criteria just put:

Between [Start Date] AND [End Date]

In the respective field.

 

[jerry28ph]

hi singh400,

I already added this just criteria on my query and it works. my problem is how can put it those two parameter value on my report. Namliam said, use it as dummy column but how can i do that?

Please extend your help on this.

Thanks,

Jerry

 

[Singh400]

In Query Builder, just add the columns [Start Date] and [End Date]. Then in your report, drag the fields from Field List onto the report. Just tested it here and it works fine.

 

[namliam]

Singh is right... just add your parameters as fields... the values of your parameters will show up as columns with the same values on all Rows. You can then put these dates anywhere you like.

 

[jerry28ph]

Thanks a lot singh400 for help. It works.
More power to you.

Appreciated your kindness.

Thanks
Jerry