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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 8
• New Files 2

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___