473,320 Members | 1,810 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

More questions

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
1 1048
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

303
by: mike420 | last post by:
In the context of LATEX, some Pythonista asked what the big successes of Lisp were. I think there were at least three *big* successes. a. orbitz.com web site uses Lisp for algorithms, etc. b....
1
by: Andrew Jones | last post by:
Hi, I have made another simple page at http://tinyurl.com/hgaa - the CSS is at http://tinyurl.com/h8cc And I have a couple more questions that I hope somebody can help me with... - How should...
0
by: Ivan Demkovitch | last post by:
Hi! This is a long one :-) Please correct me if I *did* something wrong and help me with my questions (at the end) I'm learning C# and .NET but good at SQL. I'm working on portal and...
3
by: bredal Jensen | last post by:
I'm currently downloading the Microsoft "Visual web developer 2005 Express" and i have a few questions in case someone could have insider informations about this. I have just attended a seminar...
2
by: Beffmans | last post by:
Hi I want to define more than one website in IIS is this possible? So in other words I want to define more than one localhosts ch B *** Sent via Developersdex http://www.developersdex.com...
15
by: Scott | last post by:
I'm going to start grouping all my questions in one post as this is my second today, and sorta makes me feel dumb to keep having to bother you all with trivial questions. I'll just seperate my...
23
by: sophia.agnes | last post by:
Dear all, I was going through a C book written by an indian author the following are the questions given in that book 1) consider the following statement: s1 : an operator may require an...
9
by: Elizabeth Barnwell | last post by:
This is a tool for learning the PHP programming language: http://www.yoyobrain.com/subjects/show/3120 You can look through the tabs to find information, and you can have the site quiz you to...
8
by: chanshaw | last post by:
Alright this runs just fine in IE but in firefox I get nothing function startup() { if (window.ActiveXObject) { xmlDoc=new ActiveXObject("Microsoft.XMLDOM"); }...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.