Jump to content
Sign in to follow this  
MariaAux

Print specified records twice amongst the full list?

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

A hint:

How do you interpret cPrint?

Let ( [

line = FirstName & Char (9) & LastName

] ;

line & Case ( Twice ; ¶ & line )

)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    jarvphot 
×

Important Information

By using this site, you agree to our Terms of Use.