Calculate a percentage using 2 different query totals

Duane,

It was great to hear from you and thanks again for your help earlier this
month.
I don't quite understand what you meant by SELECT query1.*, query2.*
FROM query1, query2; I assume it is code or an expression to be written some
place or is it a proceedure?

Let me try to be a little more specific about what I am trying to do.
The 2 queries are setup as follows;

1. Customer ID, Customer Name, Product, Product Type=Total Individual
Purchased
Sum Not Canceled and
Not Void

2. Product, Product Type=Total Product Sold to Everyone
Sum Sold

*What I am trying to do is show the percentage one Cusomer has purchased in
relationship to the total Product sold.

Duane, I would like to thank you in advance for your time and expert advise
in solving my dilemma.

Best Regards,
jbeck2010

"Duane Hookom" wrote:

 > If each query returns only one record, you can combine them in another
 > query.
 >
 > SELECT query1.*, query2.*
 > FROM query1, query2;
 >
 > --
 > Duane Hookom
 > MS Access MVP
 >
 >


  > >I have setup 2 separate queries to get specific totals. It is impossible to
  > > combine them into 1, as they both use 1 key field with different criteria
  > > to
  > > get the correct total.
  > >
  > > Is there any way to calculate and display, in a query or report, a
  > > percentage as it relates to those 2 totals.
  > >
  > > Example: Total bought 3,200 Total available 10,000 = 3,200/10,000=32%
  > >
  > > All I Need is the percentage to show with the appropriate record, not the
  > > calculation.
  > >
  > > Please Help,
  > > jbeck2010
  > >
 >
 >
 >
 >> Stay informed about: Calculate a percentage using 2 different query totals 

Can't you create two totals queries where the ProductID is unique in each
query. One query contains only orders from a single customer while the other
contains orders from all customers? Then join the two queries together by
the ProductID?

--
Duane Hookom
MS Access MVP


"jbeck2010" wrote in message

 > Duane,
 >
 > It was great to hear from you and thanks again for your help earlier this
 > month.
 > I don't quite understand what you meant by SELECT query1.*, query2.*
 > FROM query1, query2; I assume it is code or an expression to be written
 > some
 > place or is it a proceedure?
 >
 > Let me try to be a little more specific about what I am trying to do.
 > The 2 queries are setup as follows;
 >
 > 1. Customer ID, Customer Name, Product, Product Type=Total Individual
 > Purchased
 > Sum Not Canceled and
 > Not Void
 >
 > 2. Product, Product Type=Total Product Sold to Everyone
 > Sum Sold
 >
 > *What I am trying to do is show the percentage one Cusomer has purchased
 > in
 > relationship to the total Product sold.
 >
 > Duane, I would like to thank you in advance for your time and expert
 > advise
 > in solving my dilemma.
 >
 > Best Regards,
 > jbeck2010
 >
 > "Duane Hookom" wrote:
 >
  >> If each query returns only one record, you can combine them in another
  >> query.
  >>
  >> SELECT query1.*, query2.*
  >> FROM query1, query2;
  >>
  >> --
  >> Duane Hookom
  >> MS Access MVP
  >>
  >>


   >> >I have setup 2 separate queries to get specific totals. It is impossible
   >> >to
   >> > combine them into 1, as they both use 1 key field with different
   >> > criteria
   >> > to
   >> > get the correct total.
   >> >
   >> > Is there any way to calculate and display, in a query or report, a
   >> > percentage as it relates to those 2 totals.
   >> >
   >> > Example: Total bought 3,200 Total available 10,000 =
   >> > 3,200/10,000=32%
   >> >
   >> > All I Need is the percentage to show with the appropriate record, not
   >> > the
   >> > calculation.
   >> >
   >> > Please Help,
   >> > jbeck2010
   >> >
  >>
  >>
  >>
 >> Stay informed about: Calculate a percentage using 2 different query totals