 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / March 2008Printing labels for alumni database for 21 and older
How do I print labels for alumni that is 21 and older from my alumni database? So, I need graduating years from 1987 and previous. How do I tell it to pick just those span of years (meaning, I do NOT want graduates from the class of 1988, 1989, 1990, etc)? Right now I have under the SORTING AND GROUPING: Field/Expression=Graduating Class Year; Sort Order=Ascending Field/Expression=Last/Maiden Name; Sort Order=Ascending Field/Expression=FirstName; Sort Order=Ascending All of that is also listed under ORDER BY in the REPORT info. The RECORD SOURCE is the CONTACTS table. Under FILTER I have: (((Contacts.[Home Street Address]) Is Not Null)) so that it doesn't print address labels for those alumni I don't have addresses for. Change the The RECORD SOURCE to a query using the CONTACTS table and criteria on the graduating field <=1987 unless your field is text then <="1987".  SignatureKARL DEWEY Build a little - Test a little > How do I print labels for alumni that is 21 and older from my alumni > database? So, I need graduating years from 1987 and previous. How do I tell [quoted text clipped - 10 lines] > Address]) Is Not Null)) so that it doesn't print address labels for those > alumni I don't have addresses for. I'm not so good at this, so can you please tell me where I went wrong? Before any changes you told me to do this is what the report fields had: RECORD SOURCE: Contacts FILTER: (((Contacts.[Home Street Address]) Is Not Null)) FILTER ON: Yes ORDER BY: Contacts.[Graduating Class Year], Contacts.[Last/Maiden Name], Contacts.FirstName Now, when I click on the 3 dots next to RECORD SOURCE it tells me I invoked the Query Builder on a table. Do you want to create a query based on the table? And I answered Yes. In the FIELD I chose Graduating Class Year, which made Contacts default in the TABLE field. In the CRITERIA I typed <=1987. I saved the changes and then did a print preview, which prompted me ENTER PARAMETER VALUE for FirstName and then Last/Maiden Name and then Married Name and then Home Street Address and then Home City and then Home State/Province and then Home Zip/Postal Code...finally it gave me a print preview only showing the comma separating the city and state...no names/addresses! What did I do wrong? > Change the The RECORD SOURCE to a query using the CONTACTS table and criteria > on the graduating field <=1987 unless your field is text then <="1987". [quoted text clipped - 13 lines] > > Address]) Is Not Null)) so that it doesn't print address labels for those > > alumni I don't have addresses for. It appears that you did not add all the needed fields to the query grid. You need to add each field you want to see to the query grid. Also, you need to put criteria of Is Not Null under the Field Home Street Address in addtiontion to the criteria you have under Graduating Class Year. SignatureJohn Spencer Access MVP 2002-2005, 2007-2008 Center for Health Program Development and Management University of Maryland Baltimore County . > I'm not so good at this, so can you please tell me where I went wrong? > Before any changes you told me to do this is what the report fields had: [quoted text clipped - 42 lines] >> > those >> > alumni I don't have addresses for. Thank you. I got it. I forgot one more criteria, though. I have a column in my table that states DECEASED. The data type is Yes/No. I do NOT want labels printed for alumni that are deceased. While in REPORTS I invoke the query builder again, but I don't know what to put in the CRITERIA field. > It appears that you did not add all the needed fields to the query grid. > You need to add each field you want to see to the query grid. [quoted text clipped - 48 lines] > >> > those > >> > alumni I don't have addresses for. Put False as the criteria under the Deceased field. No quote marks around the word false. '==================================================== John Spencer Access MVP 2002-2005, 2007-2008 Center for Health Program Development and Management University of Maryland Baltimore County '==================================================== > Thank you. I got it. I forgot one more criteria, though. I have a column > in my table that states DECEASED. The data type is Yes/No. I do NOT want [quoted text clipped - 53 lines] >>>>> those >>>>> alumni I don't have addresses for. I forgot to write in my last reply...please remember all I want is address labels that are for alumni 21 and older (>=1987) and also only labels for alumni that have addresses. > Change the The RECORD SOURCE to a query using the CONTACTS table and criteria > on the graduating field <=1987 unless your field is text then <="1987". [quoted text clipped - 13 lines] > > Address]) Is Not Null)) so that it doesn't print address labels for those > > alumni I don't have addresses for. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.