Print specified records twice amongst the full list?

[MariaAux]

Hi there,

I've got a school database with a list of students. Some students attend once a week and others attend twice a week. I need to print small printouts for each student - if they come once, ONE printout, if they come twice, TWO printouts.

I could do this by printing out all the students and then printing again only the students who come twice, but this will get messy as this is not a once print-off, it is an ongoing thing over the course of the next month and it will be a waste of paper if I am prining small bits on whole pages .

I also don't want to duplicate each student's record who comes twice because then my database will lose it's accuracy. Can you think of a way that I could create a script that prints specified records twice amongst the full list?

Thanks so much for your help in advance.

[bcooney]

Print the report from the child table which is the table that stores the dates you expect the student to attend.

[comment]

Assuming you're not as organized as Barbara supposes, you could use a calculation field to return the data to print - either once or twice, depending on the student's type.

[bcooney]

Her response would be telling, now wouldn't it, Comment?

[MariaAux]

Hi Guys,

Print the report from the child table which is the table that stores the dates you expect the student to attend.

bcooney - I am printing the report from the child table (i.e students, not families), but that still doesn't cause some specified records to print twice.

Comment - Yes, I definitly need a calculation. But what kind of calculation could I use to return the data to print twice for some students? Just give me a hint please.

Thanks so much,

Maria

[comment]

But what kind of calculation could I use to return the data to print twice for some students? Just give me a hint please.

A hint:

Print2x.fp7.zip

[adyf]

A hint:

How do you interpret cPrint?

Let ( [

line = FirstName & Char (9) & LastName

] ;

line & Case ( Twice ; ¶ & line )

)