Field in a report

[Guest]

Hello,

I am creating a database for a college.

I created a report to show the dates of beginning and end of terms.

on opening the report the user is asked for a parameter value - please enter
the beginning date and then another parameter value - please enter the end
date
and then they get to see a list of the term dates between the two dates that
they put in.
I now want to make a heading for that report to say for e.g if they selected
to see term dates between 1-1-2005 and 12-1-2006 then the heading would be:

Term Dates of 2005 - 2006

or if its for only one year

Term Dates of 2005

how could i do this - what is the coding?

Thanks so much!

 

[fredg]

Hello,

I am creating a database for a college.

I created a report to show the dates of beginning and end of terms.

on opening the report the user is asked for a parameter value - please enter
the beginning date and then another parameter value - please enter the end
date
and then they get to see a list of the term dates between the two dates that
they put in.
I now want to make a heading for that report to say for e.g if they selected
to see term dates between 1-1-2005 and 12-1-2006 then the heading would be:

Term Dates of 2005 - 2006

or if its for only one year

Term Dates of 2005

how could i do this - what is the coding?

Thanks so much!

Add an unbound text control to the report header.
Set it's control source to:
= IIf(Year([please enter the beginning date]) = Year([please enter the
end date]),"Term Date of " & Year([please enter the beginning
date]),Term Dates of " & Year([please enter the beginning date]) & " -
" & Year([please enter the end date]))

Note the text within the brackets must be identical to the bracketed
text in the query criteria.

 

[Guest]

that was spot on - thanks so much!

Hello,

I am creating a database for a college.

I created a report to show the dates of beginning and end of terms.

on opening the report the user is asked for a parameter value - please enter
the beginning date and then another parameter value - please enter the end
date
and then they get to see a list of the term dates between the two dates that
they put in.
I now want to make a heading for that report to say for e.g if they selected
to see term dates between 1-1-2005 and 12-1-2006 then the heading would be:

Term Dates of 2005 - 2006

or if its for only one year

Term Dates of 2005

how could i do this - what is the coding?

Thanks so much!

Add an unbound text control to the report header.
Set it's control source to:
= IIf(Year([please enter the beginning date]) = Year([please enter the
end date]),"Term Date of " & Year([please enter the beginning
date]),Term Dates of " & Year([please enter the beginning date]) & " -
" & Year([please enter the end date]))

Note the text within the brackets must be identical to the bracketed
text in the query criteria.