People who worked outside of their homeplace

[shingouki]

Hello, i am new to access and need help with a query.
I have tables of: 1) people
2.) companies
3.) cities
4.) places

so how can i make a query that will show me people who: WORK OUTSIDE OF PLACE THEY LIVE IN.



would really apprieciate any help, i tried google and youtube but no luck so far gonna keep trying.


p.s. : english is not my native language.

[Kudos]

Assuming your People table stores the Place they live and the Company they work at, and your Company table stores the Place the company is, you would create a query that brings in Person, Person Place and Company Place and then have a field set up to return True if the two Place fields match and False if they don't. Then your filter criteria for that column will be False.

If you are able to upload your database here (and it contains no sensitive info), go ahead. Just curious, what is a Place, since it is apparently not a City?

[shingouki]

its in different language, so i think you would get lost,
but how would i exactly filter the criteria
what would i type in the criteria box, im really new to access.

[shingouki]

its in different language, so i think you would get lost,
but how would i exactly filter the criteria
what would i type in the criteria box, im really new to access.

place is something other then a city,
its like this
city,
state,
and something above state,

its 3 levels of places
but lets just say i need workers who work outside of the city they live in, how exactly would i do that?
thanks

[Kudos]

Place_Example.accdb

Maybe this little example will help.

[shingouki]

ok thanks a lot for this,
so i target the table with [place]. and record in the table with [PlaceName] , if it equals = placename in company place it will be listed in the table as true or false if it doesent equal it, and on criteria i put only false so i see which people dont live in the place they work, and i can hide the last row on query design view.
this is really what i wanted to know thanks a lot for this,
the only problem is my databse is a bit different, since we have 3 levels of places like i said,
but it should be the same, youve really helped a lot this is huge step forward.

[Kudos]

Excellent, good luck working the simple principle into your more complicated setup! Post again if you hit a snag I might be able to help with.

[shingouki]

yeah the thing is i guess, i skipped the basics went straight for the queries for an assignment,
with this example i can see how it can be done and how to select tables and records in tables in query design,
i feel really silly now for not knowing even the basic stuff.
its only couple days since i do access.
and thanks a lot my friend