Re: [libreoffice-users] base + mailmerge difficulty

2015-06-29 Thread Paul D. Mirowsky
You may be over complicating things a little bit. Create a query table using wizard including all printable fields which must also include items requiring sorting below. Sort by Student ID, then by Class ID In your ODT use Student ID in header. (I have not used OTT) Use Student ID in table.

Re: [libreoffice-users] base + mailmerge difficulty

2015-06-28 Thread Alex McMurchy
Translating form theory in base to a writer document you would have a form that contains two sub forms. The first sub form would be called Students and source it's data from the Students table and contain the controls FirstName and LastName The second sub form would be called Classes and

Re: [libreoffice-users] base + mailmerge difficulty

2015-06-27 Thread Gabriele Ponzo
The list doesn't allow attachments. Could you keep them on a xloud and link here? What i see is that you should prepare a query where you already have 14 results (even null) in a single record. Il 26/giu/2015 18:06, Ed Beroset bero...@mindspring.com ha scritto: I'm trying to print out schedules

Re: [libreoffice-users] base + mailmerge difficulty

2015-06-27 Thread Ed Beroset
Gabriele Ponzo wrote: The list doesn't allow attachments. Could you keep them on a xloud and link here? The file I tried to attach is available here: http://www.beroset.com/school.zip What i see is that you should prepare a query where you already have 14 results (even null) in a single

Re: [libreoffice-users] base + mailmerge difficulty

2015-06-27 Thread Mark LaPierre
On 06/27/15 09:17, Ed Beroset wrote: Gabriele Ponzo wrote: The list doesn't allow attachments. Could you keep them on a xloud and link here? The file I tried to attach is available here: http://www.beroset.com/school.zip What i see is that you should prepare a query where you already

[libreoffice-users] base + mailmerge difficulty

2015-06-26 Thread Ed Beroset
I'm trying to print out schedules for students using mailmerge and have encountered a problem that I haven't yet been able to solve. Here's what I've done so far. I have created a simple embedded database (named school) in base and I have three tables named Classes, Students and Schedules.