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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

GREAT Total Compared To Total Of User Selection

Status
Not open for further replies.

NicolaTesla1

Programmer
Feb 9, 2009
37
CA
Hi to all,

- We have 2 queries
- Query#1 has data items and metrics to display the GREAT TOTAL with no user prompt selection
- Query#2 has data items and metrics to display totals based on what the user selected on the prompt page
QUERY#1
-- Great Total --
[Total Sales] (NO user prompt selection)
[Total QTY] (NO user selection)
[Total QTY] / [Total Sales]
QUER#2
-- Total Based on user prompt's selection --
[Total Sales] (based on user selection)
[Total QTY] (based on user selection)
[Total QTY] / [Total Sales]
Should I create a Query#3 based on a JOIN between Query#1 and Query#2 to calculate the following:
[Total Sales] (based on user selection) / [Total Sales] (NO user prompt selection)
[Total QTY] (based on user selection) / [Total QTY] (NO user selection)

The thing is that I don't have all the same data items (ID's) on both queries (simply not all displayed on report) as for I don't really need them on both queries.

How should I deal with this? Can we even do this ?

Thank you in advance for any feed-back .
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top