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...

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...

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...

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...

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...

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">...