RE: Rolling Up 3 Separate Tables

I assume that you have these tables setup in a one-to-many relationship.
Use left joins in your select query.
In design view select the three tables. Click on Office.OfficeID and drag
to Branch.OfficeID, doubleclick on the connecting line and select the option
that say show all record from Office and only those from Branch that match.
Do the same for Branch to Department (Branch.BranchID - Department.BranchID).

In your report select 'Hide Duplicates' - Yes for Office and Branch.

--
KARL DEWEY
Build a little - Test a little


"oftenconfused" wrote:

Here's what I'm trying to do.

I have separate tables for Office, Branch and Department (moving up the
ladder). For most other tables, I link to just one of those tables, but
there are several instances where the choice could be any combination and
multiple numbers of Offices, Branches and Departments. My question is, is
there a way to a "roll" this up, to make selection (on the Form) and output
(on the Report) easier?

Thanks!
.

Relevant Pages

  • RE: Multiply qty of filtered records
    ... If you should want to try doing this with a query (which is probably the more ... etc in the bottom part of the design view. ... I do know how to get this information in a Report, ... Dim rs As DAO.Recordset ...
    (microsoft.public.access.modulesdaovba)
  • Re: Interesting form design problem: help!
    ... open in design view, click View> Sorting and Grouping (or click the toolbar ... records in a report". ... I thought it might be easier if I use a query instead then I can filter ... When I go through the wizard I choose these fields. ...
    (microsoft.public.access.forms)
  • Re: do I need more indexes?
    ... Each field in tReview is a rating of that criteria for a sample ... an annual aggregate report is needed. ... transfer all of the data to a new design. ... query; a crosstab query based on the union query ...
    (microsoft.public.access.tablesdbdesign)
  • Re: do I need more indexes?
    ... Each case in tReview is a row, ... an annual aggregate report is needed. ... transfer all of the data to a new design. ... query; a crosstab query based on the union query ...
    (microsoft.public.access.tablesdbdesign)
  • Re: "0.0" Value (not Null)... missing value in report
    ... If you open your table in design view, what data type are Sale_Price, SPC, and B_D_Option_Grp? ... Assuming they are all either Number or Currency, then I don't see any way Access could be misunderstanding the data type in the query. ... I will assume so, which leads us to conclude that the query is now fine, so the problem is with the report. ... 'CalculationChecker' report but produces a blank on my application report ...
    (microsoft.public.access.reports)
Loading