multiple fields

  1. LxQ

    find unmatched when comparing multiple fields

    I have tables that have similar data and I'd like to find unmatched records based on combinations of fields. For start, let's say I have two tables, each of them having a class_id and a mod_id field as in the following example: table1 class_id mod_id class001 mod001 class001 mod002...
  2. K

    Dynamic Pie Graph - based on two dynamic fields

    Any help is much appreciated. I apologize if it's hard to follow. I initially wrote it up in an excel attachment, but it looks like I can't attach workbooks to the thread. :( Please let me know if I can clarify. Thank you! Data Collection: Three separate teachers each surveyed their 12...
  3. T

    Creating a multiple field search function in excel VBA

    Hi there! I need to build a linked search function in VBA that also auto-updates after you enter data into the given search fields. I have been able to do this successfully with the following sections of code: Autofilter search - in a standard module Sub FilterTo1Criteria() With Sheet3 If...
  4. K

    Remove rows based on multiple fields

    I am looking to exclude a specific item from my query that is based on multiple fields. For example if I have a database of cars, greatly larger than shown below: Make | Color Ford | Red Toyota | Blue Chevy | Green Ford | Black I can't get Access to exclude only red and blue Fords. My...
  5. W

    SUMIF of multiple occasions

    Hi All, Im trying to find a formula that will allow me to return a sum from one column every time a match is found in multiple other columns... The book is detailing work done on different projects during the week and reporting the total time for each project for that week <tbody> Mins Time...
  6. J

    Looling up the value using multiple columns

    I have two tables. <table style="border-collapse: collapse; width: 108pt;" width="144" border="0" cellpadding="0" cellspacing="0"><col style="width: 35pt;" width="47"> <col style="width: 40pt;" width="53"> <col style="width: 33pt;" width="44"> <tbody><tr style="height: 15pt;" height="20">...

Some videos you may like

This Week's Hot Topics