By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,996 Members | 882 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,996 IT Pros & Developers. It's quick & easy.

More questions

P: n/a
Don
I have a very basic database that tracks days worked, hours worked, pay
rate, etc on a second job. Everything seems to be doing what I'd like it to
do (thanks to some help from you folks) with one exception.
I have it set up so that data is entered on a form and then clicking on a
button I open a report. To open the report I must input a beginning date
and an ending date. Then the report shows the data for this time period.
What I'd like to make happen, but somehow can't, is for these dates to show
up in the report header. How can I make that happen? All the dates within
these two dates show in the detail part of the report but not the beginning
and ending dates.
Thanks again,
Don..........
Oct 23 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Mon, 23 Oct 2006 22:25:29 GMT, "Don" <vz******@verizon.netwrote:

Presumably you have a report query like this:
select * from SomeTable
where JobDate between [Give Start Date:] and [Give End Date:]

In that case, you can create a textbox on your report and set the
ControlSource to:
=[Give Start Date:]

-Tom.

>I have a very basic database that tracks days worked, hours worked, pay
rate, etc on a second job. Everything seems to be doing what I'd like it to
do (thanks to some help from you folks) with one exception.
I have it set up so that data is entered on a form and then clicking on a
button I open a report. To open the report I must input a beginning date
and an ending date. Then the report shows the data for this time period.
What I'd like to make happen, but somehow can't, is for these dates to show
up in the report header. How can I make that happen? All the dates within
these two dates show in the detail part of the report but not the beginning
and ending dates.
Thanks again,
Don..........
Oct 24 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.