Search results

I really like the dynamic sql idea and appreciate the insight. I'm going to try to pull it off. I'm a bit new for such a tactic though.

So I'm building a database that allows users to make entries into the records tables and generate reports based on those records. The db has 3 tables (buildings, records, services), one query, and one report. If you open it and hit Generate Report on the switchboard you're going to get the...

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

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

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.