Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table Merging Question

Status
Not open for further replies.
Ixandantilus

Ixandantilus

IS-IT--Management
May 28, 2001
2
US
Is it possible to merge two tables by one variable in a select query and recieve output if either dataset contributes to the outcome. Example: If I have two datasets with 50 records each but only 25 match, I want the output to show 75 records, the 25 that match, and 25 from each datset that doesn't match. This is quite easy in SAS (my usual method), but Access only seems to support one sided or match mergers in queries.
 
Sort by date Sort by votes
Union query? doesn't depend on Access (or SAS, or ...) Just be sure to omit the "all" predicate.

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
286
Andrzejek
Andrzejek
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
552
lameid
lameid
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
148
Andrzejek
Andrzejek
breezett93
  • Locked
  • Question
Merging multiple records into just one 1
2
Replies
22
Views
216
breezett93
breezett93
MDGarcia
  • Locked
  • Question
Error Could not delete from specified tables 2
Replies
14
Views
443
MDGarcia
MDGarcia

Part and Inventory Search

Sponsor

Back
Top