Query a table with a relation

[mhankins]

Hi,

I simply want to run my client building query on my records table where client building = 201. However, since building numbers are stored in the buildings table. I keep coming up bust and I can't seem to solve this with my limited access knowledge. I'll attach my database.

 

[jdraw]

Can you step back and tell us what your database represents?
What are the tables for?
Do you have a list of business facts/requirements that the database is suppose to satisfy?
We really can't offer focused assistance until we understand your set up and the issue you have.

 

[mhankins]

1. Just a simple service management
2. Buildings, Records, and Service Types
3. The major goal is to be able to generate reports on the fly.

You'll see I've got the yearly and monthly reports, but we need two more. One for client building and one for service building. I can't figure that part out.

 

[Alansidman]

CrossPost: http://www.accessforums.net/queries/query-two-tables-based-common-value-33246.html

Please read here: http://www.excelguru.ca/content.php?184

See my response in the other forum.

 

[mhankins]

I'm sorry for the cross-post. Alansidman, that solved it for me. Thanks!!