I am trying to create a report that runs for a date prompted by a parameter, which works fine. Problem is, I have the report grouped by part size, and some managers would like to see all part sizes, even if there was not activity for the prompt date. Can anyone help me??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
parameter query that still shows all groups
- Thread starter christak
- Start date
Hi!
It would help to see the SQL. But I will assume that the query runs off one table and you are doing a totals query. If that is the case you may be able to get what you want by creating a second query which links the first query with the original table by part size and make the join an outer join to get all of the part sizes from the original table. You may also be able to use the original query as a subquery to get what you want.
hth
Jeff Bridgham
bridgham@purdue.edu
It would help to see the SQL. But I will assume that the query runs off one table and you are doing a totals query. If that is the case you may be able to get what you want by creating a second query which links the first query with the original table by part size and make the join an outer join to get all of the part sizes from the original table. You may also be able to use the original query as a subquery to get what you want.
hth
Jeff Bridgham
bridgham@purdue.edu
Write a query to filter the table with the activity date to just that date or date range. You don't need to include the parts table yet.
The second query should use the parts table outer joined to the first query. This should run more efficiently.
The second query should use the parts table outer joined to the first query. This should run more efficiently.
- Status
Similar threads
- Question
- Locked
- Question
