Access XP

[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?

 

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

 

[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;

 

[John Vinson]

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]

 

[John Vinson]

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]