Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Range in a Report
- Thread starter rogerarce
- Start date
67peshawar294
Technical User
hi roger,
create a query. In the criteria section of the date enter:
Between [Enter begin date] and [enter end date]
Create your report with the query. In record source of report place the name of the query.
When you open the report a "Enter Paramater value" box will appear. Input a valid date and click ok or press enter. A second "Enter Parameter value" box will appear. Enter a valid date etc... when you press enter your report should give you all the info on your report between the first and second date.
Jim
create a query. In the criteria section of the date enter:
Between [Enter begin date] and [enter end date]
Create your report with the query. In record source of report place the name of the query.
When you open the report a "Enter Paramater value" box will appear. Input a valid date and click ok or press enter. A second "Enter Parameter value" box will appear. Enter a valid date etc... when you press enter your report should give you all the info on your report between the first and second date.
Jim
you can also do the following:
>Date()-[Enter # of Days]
The above should give you records for the last X number of days.
Say you wanted the report to show what date ranges were entered into the "Enter Paramater value" box?
Add 2 unbound fileds onto your report and in those fileds type the following:
type into unbound field #1: enter starting date
type into unbound field #2: enter ending date
that's my $.02
SA
>Date()-[Enter # of Days]
The above should give you records for the last X number of days.
Say you wanted the report to show what date ranges were entered into the "Enter Paramater value" box?
Add 2 unbound fileds onto your report and in those fileds type the following:
type into unbound field #1: enter starting date
type into unbound field #2: enter ending date
that's my $.02
SA
Guest_imported
New member
- Jan 1, 1970
- 0
hey i have a daterange but if i click on the preview button i wanna got to other form where all my entries is listed in a dropdown... from there i can able to handel it.. my problem is how to link this two forms..
For candia -
Just add an unbound text field to your report - In the control source refer to the form field that contains the information
An example would be:
="Sales received from " & [Forms]![yourformname].[yourfirstfield] & "through" & " " & [Forms]![yourformname].[yoursecondfield]
Where you would replace "yourformname" with the name of your form and the two fields "yourfirstfield" and "yoursecondfield" with your field names (a date range on your form for example.
Hope that helps.
Just add an unbound text field to your report - In the control source refer to the form field that contains the information
An example would be:
="Sales received from " & [Forms]![yourformname].[yourfirstfield] & "through" & " " & [Forms]![yourformname].[yoursecondfield]
Where you would replace "yourformname" with the name of your form and the two fields "yourfirstfield" and "yoursecondfield" with your field names (a date range on your form for example.
Hope that helps.
Guest_imported
New member
- Jan 1, 1970
- 0
I have also attempted to do this, but I am getting an error message that says:
"The Microsoft Jet database engine does not recognize '[Type beginning date:]' as a valid field name of expression".
What does this mean? I've checked the format of the field and it seems it should be working.
Thanks!
"The Microsoft Jet database engine does not recognize '[Type beginning date:]' as a valid field name of expression".
What does this mean? I've checked the format of the field and it seems it should be working.
Thanks!
- Status
Similar threads
- Locked
- Question
