Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access XP

Discussion in 'Information Technology' started by cindy, Jul 28, 2006.

Tags:
  1. cindy

    cindy
    Expand Collapse
    Guest

    I have created a query for 4 different departments. I created a 5th query to
    pull the 4 together so I could print a report. My 5th query keeps asking to
    group by department. How can I just print the report without grouping by
    department?
     
  2. Loading...


  3. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    Show us the SQL. Open the queries in design view. Next go to View, SQL View
    and copy and past it here. Information on primary keys and relationships
    would be a nice touch too.
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "cindy" wrote:

    > I have created a query for 4 different departments. I created a 5th query to
    > pull the 4 together so I could print a report. My 5th query keeps asking to
    > group by department. How can I just print the report without grouping by
    > department?
     
  4. cindy

    cindy
    Expand Collapse
    Guest

    SELECT [2nd Stage Base Query].Date, [2nd Stage Base Query].Machine, [CREW1
    RUNTIME].[ACTUAL UNITS BUILT], [CREW1 RUNTIME].[Run Time], [CREW2
    RUNTIME].[ACTUAL UNITS BUILT], [CREW2 RUNTIME].[Run Time], [CREW3
    RUNTIME].[ACTUAL UNITS BUILT], [CREW3 RUNTIME].[Run Time], [CREW4
    RUNTIME].[ACTUAL UNITS BUILT], [CREW4 RUNTIME].[Run Time]
    FROM ((([2nd Stage Base Query] INNER JOIN [CREW1 RUNTIME] ON [2nd Stage Base
    Query].Date = [CREW1 RUNTIME].Date) INNER JOIN [CREW2 RUNTIME] ON [2nd Stage
    Base Query].Date = [CREW2 RUNTIME].Date) INNER JOIN [CREW3 RUNTIME] ON [2nd
    Stage Base Query].Date = [CREW3 RUNTIME].Date) INNER JOIN [CREW4 RUNTIME] ON
    [2nd Stage Base Query].Date = [CREW4 RUNTIME].Date;


    "Jerry Whittle" wrote:

    > Show us the SQL. Open the queries in design view. Next go to View, SQL View
    > and copy and past it here. Information on primary keys and relationships
    > would be a nice touch too.
    > --
    > Jerry Whittle
    > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
    >
    >
    > "cindy" wrote:
    >
    > > I have created a query for 4 different departments. I created a 5th query to
    > > pull the 4 together so I could print a report. My 5th query keeps asking to
    > > group by department. How can I just print the report without grouping by
    > > department?
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 18 Jul 2006 07:22:02 -0700, cindy
    <cindy@discussions.microsoft.com> wrote:

    >I have created a query for 4 different departments. I created a 5th query to
    >pull the 4 together so I could print a report. My 5th query keeps asking to
    >group by department. How can I just print the report without grouping by
    >department?


    By correcting the error in the query.

    Since you have not posted the query in SQL view, it's impossible for
    anyone here to help you do so.


    John W. Vinson[MVP]
     
  6. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 18 Jul 2006 09:14:01 -0700, cindy
    <cindy@discussions.microsoft.com> wrote:

    >SELECT [2nd Stage Base Query].Date, [2nd Stage Base Query].Machine, [CREW1
    >RUNTIME].[ACTUAL UNITS BUILT], [CREW1 RUNTIME].[Run Time], [CREW2
    >RUNTIME].[ACTUAL UNITS BUILT], [CREW2 RUNTIME].[Run Time], [CREW3
    >RUNTIME].[ACTUAL UNITS BUILT], [CREW3 RUNTIME].[Run Time], [CREW4
    >RUNTIME].[ACTUAL UNITS BUILT], [CREW4 RUNTIME].[Run Time]
    >FROM ((([2nd Stage Base Query] INNER JOIN [CREW1 RUNTIME] ON [2nd Stage Base
    >Query].Date = [CREW1 RUNTIME].Date) INNER JOIN [CREW2 RUNTIME] ON [2nd Stage
    >Base Query].Date = [CREW2 RUNTIME].Date) INNER JOIN [CREW3 RUNTIME] ON [2nd
    >Stage Base Query].Date = [CREW3 RUNTIME].Date) INNER JOIN [CREW4 RUNTIME] ON
    >[2nd Stage Base Query].Date = [CREW4 RUNTIME].Date;
    >


    In what way does this query "ask to group by department"??? There
    isn't even a Department field MENTIONED. What do you see when you open
    the query itself in datasheet view?

    Could you perhaps have a Sorting and Grouping defined for the Report,
    specifying the department?


    John W. Vinson[MVP]
     

Share This Page