Creating a listing from multiple tables in Access 2007

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have built a realational database in Access 2007 with 9 tables, queries and forms for the 9 different types of tools we use. Each type of tool is or can be in many different locations, so I have a field called 'Location' in the tables for the tools, as well as 6/7 other fields.

What I would now like to do is to have access2007 create me a list if all the tools in a specified location.

Could someone please direct me on the best way of doing this, bearing in mind that I am still learning Access 2007 and am using a book: Access 2007 Inside Out, where I am about a quarter way through it so far.

Thanks
.

Relevant Pages

  • Re: Access apps with user definable fields?
    ... New fields would need to added to tables, queries, ... Of course they have their own built in report writer ... > I have an app I built for nonprofits who provide FREE ... > add control switches to control whether certain fields are displayed or ...
    (microsoft.public.access.formscoding)
  • Re: Entering data in one form while updates 2 or more tables
    ... query, which was built from two queries and one table. ... you can certainly use VBA code in the form's AfterUpdate event to open a ...
    (microsoft.public.access.forms)
  • Re: How do I add a record?
    ... eslinc wrote: ... I just built the form using ... but not all queries allow updating the data. ... are using such a query that would explain why you couldn't make changes. ...
    (microsoft.public.access.forms)
  • Re: How to allow a Query to Delete Records
    ... queries that allowed me to delete records, ... I wondered what the unmatched query wizard would do. ... and the wizard built ones was that the wizard used SELECT DISTINCTROW ...
    (microsoft.public.access.modulesdaovba)