ACCESS FEED: Re: [MS_AccessPros] not appending all records???

Kamis, 01 Desember 2011

Re: [MS_AccessPros] not appending all records???

Hi John,

I figured out my problem.

Thanks.

Tiffany

________________________________
From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, December 1, 2011 1:34 PM
Subject: RE: [MS_AccessPros] not appending all records???

What is the SQL of your query?

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of cc0623
Sent: Thursday, December 01, 2011 8:54 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] not appending all records???

I created an unmatched query between two tables Assets and sold. The key between
tables is Unit. There are approxiamtely 100 records that are in sold that needs
to be in assets, the Sold has duplicates in Assets. The query is showing no
unmatched records. Not sure what I have done wrong here.

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]