I'm trying to format a report so that it will come out in print form as a series of individual letters. The table the report is based on consists of one field for the name, several fields for the address and another field for some data text. The same name may appear from one to six times, each time associated with a different data text. I've grouped by the name, so that should only appear on the page once. For every letter the page header and page footer are the same, but for each individual letter there is a set of fields for the name and address (which should only appear once), and then a set of fields for the text data, a variable number of fields, from one to six,arranged vertically. I've tried putting the name, address and information fields in various segments of the report and inserting a page break at different points, but the results are very confusing. Sometimes two sets of addresses appear on the same page, sometimes data fields associated with a different name appear on the same page as the previous name, and sometimes the address appears as many times as the data fields with only one data field associated with the address. How can I make this work?
Report as a letter
- Thread starter Leathem
- Start date
I could do that, but it doesn't help with the formatting problem. The duplication of names doesn't arise here though, since the "name" field is a concatination of first and last names. Individual first and last name fields are used for other purposes.
I'm not sure I follow you. I found on the Properties for the report a line for "Grp Keep Together", which I changed to "Per Page", but it didn't solve the problem. I also went into the "Group, Sort and Total" section of the Design view of the report and under the grouping options chose group on name, with A on top, by entire value, with a header section, with a footer section, and Keep whole group together on one page. But in the print view I'm still seeing more than one name on a page, with the page header at the top of the page and the page footer at the bottom.
I see how to make the footer invisible in the Properties section, but I can't find any option for starting a new page. I'm also not sure what you mean by the "Group footer". In design view I see the sections Report Header, Page Header, StudentName Header, Detail, StudentName Footer, Page Footer and Report Footer. I have the name and address fields in the StudentName header and the data to be presented is in the Detail section. The return address (a constant) is in the Page Header, and the "yours truly" is in the Page Footer. Nothing's in the Report Header or Report Footer.
I pointed out to you in an earlier post that you shouldn't be grouping by StudentName but rather group by an ID. Again I would mention that it will not print two separate pages if there exists two students with the same name.
If you click the StudentID footer bar and look in the Property Sheet, you will find the Force New Page property.
If you click the StudentID footer bar and look in the Property Sheet, you will find the Force New Page property.
eureka! That did it! Your suggestion about the property sheet for the StudentID footer bar worked (oh, and yes, I took your suggestion about changing the grouping to the ID number rather than the name; you were quite correct.).
Thank you so much!
Thank you so much!
I have a report issue where I am using a report to generate a form letter (like a mail merge). In the body of the letter I would like to include a number figure that is calculated in the underlying query. I was able to create a text box and insert the figure in the middle of the verbiage. However, the figure appears as just a plain number such as 4662... what I would like to see is $4,662.00. Is there any way I can get this format included in the body of the text box? The figures range anywhere from $1,000 to $100,000.
In the Propery Sheet, under the Format tab you will find a Format property, select Currency from the drop down list. That will do it.
I tried it but it doesn't work. I clicked on the text box and then went into the properties and changed the format to currency. It didn't work and I'm thinking maybe it doesn't work because there is verbiage in the box also. This is an example of what's in the box...
="...In addition to non-resident documents, we are enclosing the invoice(s) stating the amount due. Please make your check payable to Monticello Central School District in the amount of " & Sum([Amount Due]) & " and send to my attention..."
I would piece it all together seperately but I don't want any extra spaces when a lower number is pulled in as opposed to a larger one.
Any other thoughts?
="...In addition to non-resident documents, we are enclosing the invoice(s) stating the amount due. Please make your check payable to Monticello Central School District in the amount of " & Sum([Amount Due]) & " and send to my attention..."
I would piece it all together seperately but I don't want any extra spaces when a lower number is pulled in as opposed to a larger one.
Any other thoughts?
Here you go:
Code:
="...In addition to non-resident documents, we are enclosing the invoice(s) stating the amount due. Please make your check payable to Monticello Central School District in the amount of " & Format(Sum([Amount Due]), "Currency") & " and send to my attention..."
