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