too many merged records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In publisher: I'm using a query (find unmatched query wizard) in access as
the merge information for my publisher piece. There are more records in the
merge than there are in the query result. I am using two creteria to create
the
query.
field creteria
[mailprogram] 20 days
[mailaddress] not like *ggw bad address*

The query gives me the correct records. In the merge records I get the
correct records for "20 days" but I also get the records that should be
excluded (and are excluded in the query:not like *ggw bad address*) in the
merged records. How can this
be?
 
In publisher: I'm using a query (find unmatched query wizard) in access as
the merge information for my publisher piece. There are more records in the
merge than there are in the query result. I am using two creteria to create
the
query.
field creteria
[mailprogram] 20 days
[mailaddress] not like *ggw bad address*

The query gives me the correct records. In the merge records I get the
correct records for "20 days" but I also get the records that should be
excluded (and are excluded in the query:not like *ggw bad address*) in the
merged records. How can this
be?
Click to expand...

Please open the Query in SQL view and post the SQL here. The grid is
useful for creating queries but it's not ideal for communicating the
query's structure!

John W. Vinson[MVP]
 
SELECT [Mailing List All Unsent].MAILPROGRAM, [Mailing List All
Unsent].M0VEDATE, [Mailing List All Unsent].SENTMETRO, [Mailing List All
Unsent].[GGW Update], [Mailing List All Unsent].OWNERFIRST, [Mailing List All
Unsent].OWNERLAST, [Mailing List All Unsent].MAILADDRES, [Mailing List All
Unsent].MAILCITY, [Mailing List All Unsent].MAILSTATE, [Mailing List All
Unsent].MZIPANDZIP, [Mailing List All Unsent].MLNUM, [Mailing List All
Unsent].STATUS, [Mailing List All Unsent].ADR, [Mailing List All
Unsent].AREA, [Mailing List All Unsent].CITY, [Mailing List All
Unsent].OFFMKTDT, [Mailing List All Unsent].ExprA, [Mailing List All
Unsent].STATCHDT, [Mailing List All Unsent].EXPIRDAT, [Mailing List All
Unsent].ExprB, [Mailing List All Unsent].OWNRNAME, [Mailing List All
Unsent].ZIPCODE, [Mailing List All Unsent].COMPLEX, [Mailing List All
Unsent].LOTSIZE, [Mailing List All Unsent].DAYSOMKT, [Mailing List All
Unsent].BEDROOMS, [Mailing List All Unsent].BATHROOM, [Mailing List All
Unsent].LOTSIZED, [Mailing List All Unsent].SALEPRIC, [Mailing List All
Unsent].APPGSQFT, [Mailing List All Unsent].LSPRC, [Mailing List All
Unsent].REMARKS, [Mailing List All Unsent].REMKSLN4, [Mailing List All
Unsent].GRSCHINC, [Mailing List All Unsent].GRSRNMUL, [Mailing List All
Unsent].TOTUNITS, [Mailing List All Unsent].APPRACRE, [Mailing List All
Unsent].CROSSST, [Mailing List All Unsent].LISTDATE, [Mailing List All
Unsent].SALEDATE, [Mailing List All Unsent].ORIGLSPR, [Mailing List All
Unsent].ORIGLSDT, [Mailing List All Unsent].TOUR1, [Mailing List All
Unsent].VIEWTYPE, [Mailing List All Unsent].AGE, [Mailing List All
Unsent].ANGRSINC, [Mailing List All Unsent].ANNEXP, [Mailing List All
Unsent].NETINCOM, [Mailing List All Unsent].CAPRATE, [Mailing List All
Unsent].OCCPDBY, [Mailing List All Unsent].SHOWINST, [Mailing List All
Unsent].MLSAREAMETRO, [Mailing List All Unsent].Expr1, [Mailing List All
Unsent].PARCEL, [Mailing List All Unsent].MAILNUMBER, [Mailing List All
Unsent].MAILSTREET, [Mailing List All Unsent].SITENUMBER, [Mailing List All
Unsent].SITESTREET, [Mailing List All Unsent].SITECITY, [Mailing List All
Unsent].Legal1, [Mailing List All Unsent].sitezip, [Mailing List All
Unsent].OWNERSTATUS, [Mailing List All Unsent].MAPGRID, [Mailing List All
Unsent].MAPPAGE, [Mailing List All Unsent].NBRHDCDE, [Mailing List All
Unsent].PRICE, [Mailing List All Unsent].DOCDATE, [Mailing List All
Unsent].USECD_USE, [Mailing List All Unsent].PHONE, [Mailing List All
Unsent].TENANTPH, [Mailing List All Unsent].DAYSOUT
FROM [Mailing List All Unsent] LEFT JOIN [Mailing List All Sent] ON [Mailing
List All Unsent].ExprA = [Mailing List All Sent].ExprA
WHERE ((([Mailing List All Unsent].MAILPROGRAM)="20 days") AND (([Mailing
List All Unsent].MAILADDRES) Not Like "*ggw*") AND (([Mailing List All
Sent].ExprA) Is Null));

John Vinson said:
In publisher: I'm using a query (find unmatched query wizard) in access as
the merge information for my publisher piece. There are more records in the
merge than there are in the query result. I am using two creteria to create
the
query.
field creteria
[mailprogram] 20 days
[mailaddress] not like *ggw bad address*

The query gives me the correct records. In the merge records I get the
correct records for "20 days" but I also get the records that should be
excluded (and are excluded in the query:not like *ggw bad address*) in the
merged records. How can this
be?
Click to expand...

Please open the Query in SQL view and post the SQL here. The grid is
useful for creating queries but it's not ideal for communicating the
query's structure!

John W. Vinson[MVP]
Click to expand...
 
WHERE ((([Mailing List All Unsent].MAILPROGRAM)="20 days") AND (([Mailing
List All Unsent].MAILADDRES) Not Like "*ggw*") AND (([Mailing List All
Sent].ExprA) Is Null));
Click to expand...

If the LEFT JOIN doesn't match a record in [Mailing List All Unsent]
then the criteria on fields in that table will certainly NOT contain
"20 days" or "ggw"... they'll be NULL.

What you'll need to do is create a Query on [Mailing List All Unsent]
with those criteria, and left join *to that query* rather than to the
table itself.

John W. Vinson[MVP]
 
OK.But how come the query results are good but not so when merged with the
publisher object?

John Vinson said:
WHERE ((([Mailing List All Unsent].MAILPROGRAM)="20 days") AND (([Mailing
List All Unsent].MAILADDRES) Not Like "*ggw*") AND (([Mailing List All
Sent].ExprA) Is Null));
Click to expand...

If the LEFT JOIN doesn't match a record in [Mailing List All Unsent]
then the criteria on fields in that table will certainly NOT contain
"20 days" or "ggw"... they'll be NULL.

What you'll need to do is create a Query on [Mailing List All Unsent]
with those criteria, and left join *to that query* rather than to the
table itself.

John W. Vinson[MVP]
Click to expand...
 
OK.But how come the query results are good but not so when merged with the
publisher object?
Click to expand...

I'd suggest you ask in a Publisher newsgroup: I have no idea!

John W. Vinson[MVP]
 
Back
Top