Re: Printing labels for alumni database for 21 and older

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" wrote:

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" <tjsmags@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1B74627D-A8E7-4D70-971C-D0D0D217F3D2@xxxxxxxxxxxxxxxx
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" wrote:

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" wrote:

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.





.

Relevant Pages

  • Re: Printing labels for alumni database for 21 and older
    ... While in REPORTS I invoke the query builder again, but I don't know what to put in the CRITERIA field. ... "John Spencer" wrote: ... 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. ...
    (microsoft.public.access.reports)
  • Re: Printing labels for alumni database for 21 and older
    ... It appears that you did not add all the needed fields to the query grid. ... Address in addtiontion to the criteria you have under Graduating Class Year. ... Married Name and then Home Street Address and then Home City and then Home ...
    (microsoft.public.access.reports)
  • Complex query criteria - desperate appeal
    ... This manager I'm making this for has about 13 different criteria he likes to ... for Access to handle using the query builder. ... Someone mentioned using a SQL string and code to change the query ... results, rather than using specific queries, but I either don't know how to ...
    (microsoft.public.access.queries)
  • RE: using the results of a function for Criteria
    ... In query builder when you put in ... 'red' and 'green' for criteria it writes in sql veiw as "WHERE ... You need to use where clause of the docmd.open report ...
    (microsoft.public.access.queries)
  • input
    ... In the query builder, simply put the following in the ... criteria line under GPA: Between And ... >want to extract students whose GPA is between an input ...
    (microsoft.public.access.formscoding)