Query and Mail List Database

  • Thread starter Thread starter Vince
  • Start date Start date
V

Vince

Hello:
I am a novice at using MS ACESS vers 2.0 and am having a problem with
the results of my first attempt in generating address labels. I also
have MS Word 97 running on a WIN98se computer.

I have printed out a Form with 40 address labels, but there are four
records that contain errors. I have corrected the db Table.

I thought that I could use a Query to separate those four records by
specifying the Mailing List ID numbers. However, the Query Wizzard
seems to allow for just ONE criterum. I must be missing something !

Is there a way to include more than one record in the Query criteria ?

Should I be approaching this in a different manner, such as generating
an archive database table and then deleting all but the four records ?
That seems like a lot more work .

Please suggest method(s) for accomplishing this correction project.

TNX
~ Vince ~
 
Well, the ideal thing would be to fix what's wrong with
those 4 records so they will print correctly. If they just
should flat not be printed, you could exclude them
individually, but that seems like a lot of work unless this
is a one-shot and you're in a hurry.

But for future reference, to exclude more than 1 criteria,
use the AND and NOT operators.
In this for-instance, in the criteria portion of the ID
field in your query, type in NOT 1234 AND 1235 AND 1236 AND
1237. When you click somewhere else, you'll see the 4
numbers get enclosed in quotes, and the operator LIKE will
be added before each one - Access nowadays does that
automatically for you. That will exclude the 4 numbers you
want.
 
Hello Rose, and TNX:

I realize that there is probably several methods possible to print the
corrected four records onto address labels. Use of boolean operators
is one that I am familiar with, but did not realize that those are
possible in vers 2.0 MS Access. I suppose that I will stay with the
Query approach.

As it turns out, my wife informed me that 10 return address labels
(for same address) are needed, along with 3 existing typo records that
needed correction. In this case, I want to exclude all records but
the 3 that have been corrected and the one additional (as the return
address source).

TNX again.
 
I am trying to make use of the Archive type Query Wizzard to resolve
my problem.

MailingListID is the Primary Key field. However, when attempting to
enter the (MailingListID) numbers into the "This Value" wizzard
field, I am shown an error message that says: The value entered does
not correspond to the data type of [MailingListID].....
I entered the following: 9 AND 14 AND 36 AND 41 in an attempt to
transfer only those four records into the Archive Table to be
generated.

What is the correct data type: Counter ?
How can I enter the correct data type for: Counter into the "This
Value" Archive Query wizzard field? Must I change the data type for
the MailingListID within the table design field ?

As I have previously mentioned, this is all new to me, so please
excuse my ignorance and my clutching at straws.
 
I am trying to make use of the Archive type Query Wizzard to resolve
my problem.

MailingListID is the Primary Key field. However, when attempting to
enter the (MailingListID) numbers into the "This Value" wizzard
field, I am shown an error message that says: The value entered does
not correspond to the data type of [MailingListID].....
I entered the following: 9 AND 14 AND 36 AND 41 in an attempt to
transfer only those four records into the Archive Table to be
generated.
Click to expand...

Rose was mistaken; the AND operator connects two logical expressions
and returns the record if they are both TRUE (nonzero).

The correct syntax to retrive these four records would be either

[MailingListID] = 9 OR [MailingListID] = 14 OR [MailingListID] = 36 OR
[MailingListID] = 41

which will return the record if it is any one of these four; or, in a
more compact and more efficient syntax, use a criterion of

IN (9, 14, 36, 41)
 
Back
Top