Report Headers

  • Thread starter Conditional entries in report headers
  • Start date
C

Conditional entries in report headers

ACCESS 2000

I have created a report when you open it, you are promted to enter a start
date and an end date.

How do I set up a text box in my Report Header to show the following:
"Those who are due to requalify between [Start Date] and [End Date]"

date format: dd-MMM-yyyy
 
R

Rick Brandt

Conditional said:
ACCESS 2000

I have created a report when you open it, you are promted to enter a
start date and an end date.

How do I set up a text box in my Report Header to show the following:
"Those who are due to requalify between [Start Date] and [End Date]"

date format: dd-MMM-yyyy
Click to expand...

Use a TextBox with the expression...

="Those who are due to requalify between " &
Format([Start Date],"dd-mmm-yyyy") &
" and " &
Format([End Date],"dd-mmm-yyyy")

The text in the square brackets must be *exactly* the same as the parameters
in your query or it will not work.
 
F

fredg

ACCESS 2000

I have created a report when you open it, you are promted to enter a start
date and an end date.

How do I set up a text box in my Report Header to show the following:
"Those who are due to requalify between [Start Date] and [End Date]"

date format: dd-MMM-yyyy
Click to expand...

In an unbound control:
="Those who .... between " & [Start Date] & " and " & [End Date]

The text within the brackets must be identical to the query bracketed
text.
If you need to reformat the date entries, then use
& Format([Start Date],"dd-mmm-yyyy") " and " Format([End
date],"dd-mmm-yyyy")
 
D

Dustin

How did you create that type of a filter, because I would like to do
something similar to where my client can view only the reports with a date
they specify?
 
Top