Results 1 to 7 of 7

Thread: [RESOLVED] [ACCESS][EXCEL] Show only vales that do NOT match? Find NOT

Threaded View

  1. Apr 21st, 2011, 04:29 PM #1
    forthelove
    forthelove is offline

    Thread Starter
    New Member
    Join Date
    Apr 2011
    Posts
    3

    Resolved [RESOLVED] [ACCESS][EXCEL] Show only vales that do NOT match? Find NOT

    Hello all, I've been utilizing this incredible resource for quite some time, and have finally come across a problem I couldn't find already solved here. I'm really having a hard time even labeling the issue.

    I'm pretty new to excel, and very new to access. The data originates in Access but I'm more comfortable dealing with excel so I have exported the data there.

    I'm not picky how the problem is solved, can be vba or formula, or if a simple access query can be used then that would be most excellent I will be grateful to see any way to solve it.

    The problem is to compare the assembly list against each part. I already know which assemblies the part is in, but I can't seem to find a way to calculate which assemblies from the table it is NOT in.

    I have attached an img of the table as well as the xls file itself as an example. Im unsure of how else to post the data. sorry!

    Thank you all for your help, great community!
    Attached Images Attached Images  
    Attached Files Attached Files
    Last edited by forthelove; Apr 22nd, 2011 at 10:23 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width