Print Label when certian condition is met.

[talktime]

i have a report that serves the pupose of reminder to students that they have not paid their fee of the months listed in detail section, listing of month varies student to student, some student have only current month fee due, some have 3 or 4 month fee due, i want a label "Last reminder" to print on those students whose outstanding fee is more than current month i.e. current plus previous months. if a student has only current month fee due, this label should not be printed on his reminder. a sample of my report designe is attached.

[June7]

Best to use a textbox with an IIf expression in ControlSource to display text if condition is met. Just don't know enough about your db to advise how to test for the condition. Count the months listed in the Detail section?

[talktime]

i have figured out some what, i put a text box in Student ID footer section and in the control source property i put the formula =sum([Amount], which gives me the total amount due for the student, if the amount is greater than 3600, it should display the label, if it isn't should not. but
its works but a few exceptions, its working but in certain records when the amounts exceeding 3600 its not displaying the label, i don't know why its behaving like this, although there is nothing special with those records.

[June7]

Try a textbox called something like CountMonths in the StudentID Header with expression: =Count(*) The textbox can be set not visible.

Then the textbox for the 'label' would have expression: =IIf([CountMonths]>1, "Last Reminder", Null). Set this textbox visible but with no border if you don't a blank box to show.

Might be able to do with one textbox: =IIf(Count(*)>1, "Last Reminder", Null)