If statements in reports?

[UniqueTII]

I am making reports for students' work study verification forms, and what I need to do is say whether the term is "summer" or "academic year" based on the start and finish dates of work. Is it possible to say that if the start date is after May 16th the term is summer?

For example, one of the lines on the report is:
The academic year College Work-Study award is $" & [CWS Eligibility]
where CWS Eligibility is the total amount the student can earn on work study. What I need to do is change the text that says "academic year" based on the start date of the job. Would it be a better idea to change the query where I got the values for the report to include a summer/academic_year value, and if so, how would I do that?

[This message has been edited by UniqueTII (edited 04-18-2002).]

 

[ListO]

This shouldn't be too difficult. You've only got to make a statement that'll check the startdate of the job against the cut-off date between academic year and summer.

Create a textbox, and put the judgement criteria in the control source statement.

Presume that the startdate of the job is in the number dtStartDate, and the cut-off date is dtCutoffDate.

The control source for the textbox should be:
="The "& Iif[dtStartDate]>[dtCutoffDate], "summer","academic year") & " College Work-Study award is $" & [CWS Eligibility]

The values of dtStartDate and dtCutoffDate need to be in a table attached to the report.

if the dtStartDate is greater than the dtCutoffDate, it will show:
The summer college Work-Study award is $2

if the dtStartDate is less than the dtcutoffdate, it will show:
The academic year Work-Study award is $2

NOTE: This was originally posted with a typo in the if statement.

[This message has been edited by ListO (edited 04-23-2002).]

 

[UniqueTII]

Thanks a million! I'll give that a shot at work tomorrow. I found out a way to do it using a query, but your way sounds a lot easier.