Printing labels for alumni database for 21 and older

  • Thread starter Thread starter tjsmags
  • Start date Start date
T

tjsmags

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".
 
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?

KARL DEWEY said:
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".
--
KARL DEWEY
Build a little - Test a little


tjsmags said:
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.
Click to expand...
Click to expand...
 
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.

KARL DEWEY said:
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".
--
KARL DEWEY
Build a little - Test a little


tjsmags said:
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.
Click to expand...
Click to expand...
 
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.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

tjsmags said:
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?

KARL DEWEY said:
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".
--
KARL DEWEY
Build a little - Test a little


tjsmags said:
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.
Click to expand...
Click to expand...
Click to expand...
 
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.

John Spencer said:
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.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

tjsmags said:
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?

KARL DEWEY said:
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".
--
KARL 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
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.
Click to expand...
Click to expand...
Click to expand...
 
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
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.

John Spencer said:
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.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

tjsmags said:
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".
--
KARL 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
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top