Computer Forums

Member Login

Remember Me? Sign Up! | Forgot Password
 
Slogan
 
Closed Thread
Old 07-29-2005, 01:41 AM   #1 (permalink)
 
Newb Techie

Join Date: Jul 2005

Posts: 6

frika

Default Access 2000

I want to compare 2 tables in Access 2000 extracting the matching entries. I can extract the "Unmatched" entries using a wizzard. What formulae do I use to extract the mathed entries ?
frika is offline  
Old 07-31-2005, 10:25 PM   #2 (permalink)
 
True Techie

Join Date: Apr 2005

Posts: 193

Seiken

Default

How big are these tables? I'm rusty in Access, it's one of those programs where you forget more and more as you use it less.

Anyways, as for a "formula," you may want to create a query out of those two tables and grab and display the information that doesn't match between the two. I'm not quite sure how to do this.
Seiken is offline  
Old 08-01-2005, 01:15 AM   #3 (permalink)
 
Newb Techie

Join Date: Jul 2005

Posts: 6

frika

Default

Thank you I did find the soplution.
frika is offline  
 
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On