Where

**kwooten** · 11-09-2011, 01:36 PM

How does a "WHERE" work? I have a Name list in one table and a Name list in another table and only want the records where the 2 names are equal.

**RuralGuy** · 11-09-2011, 02:15 PM

Have you tried to use the built in Query Builder yet?

**kwooten** · 11-09-2011, 02:17 PM

No.. I'll give it a shot

**RuralGuy** · 11-09-2011, 02:21 PM

Post back here if you still need assistance as there are dozens of helpers here that can assist.

**kwooten** · 11-09-2011, 02:23 PM

That didnt work... I have a table (table 1) with the person ID and Created User. I have to get their advisor which is in another table (table 2) by SSN so I link table 2 to another table (table 3) to get the name of advisor. Then in table 4 is link the Created User from table 1 to table 4 to get the created name. I need only the records where the advisor = the created name.

**RuralGuy** · 11-09-2011, 02:26 PM

Why are you looking for a name instead of an ID Number?

**kwooten** · 11-09-2011, 02:27 PM

Cause I have to build a report that shows the number of contacts by name.

**kwooten** · 11-09-2011, 02:28 PM

I have seemed to have made the habit of making Access harder than it is so I am open to suggestions.

**RuralGuy** · 11-09-2011, 02:31 PM

You can set up a relationship for your tables based on the ID's of the people. Then when you include both tables in a query, all of the fields of both tables are available as if they were in one table.

**kwooten** · 11-09-2011, 02:34 PM

Initially that was sort of what I did but had one query with the person data, then in a new query built in the advisor. I had it done yesterday and it was running right. I got in this morning and it was all messed up and i dont know what i originally did.

**RuralGuy** · 11-09-2011, 02:38 PM

I usually start over when that happens. I'm sure you will do it better the second time.

**kwooten** · 11-09-2011, 02:40 PM

right now, I have one table that has my employees and their advisors along with the user id of the creator of the record. Now I can get the user name of the creator but i cant get it to only show me the records where the User and Advisor are the same.

Really what this system does is tracks how many calls have been made. The reason for the creator is because someone other than that employees advisor can call them, but I only care about how may employees in the advisors "portfolio of employees" was contacted by the assigned advisor.

**kwooten** · 11-09-2011, 02:41 PM

I know I had the first file showing the data based on a join but i cant seem to get it figured out again.

**RuralGuy** · 11-09-2011, 02:48 PM

It sounds like you need to make a query with 2 copies of that table.

**kwooten** · 11-09-2011, 03:05 PM

I included the contacted employees id and it gave me more records. Its still not right though.. Why would including another field increase the number of records?

Where

Thread Tools

Where

Posting Permissions