formulating cross-product query

Results 1 to 2 of 2

Thread: formulating cross-product query

  1. #1
    Join Date
    Dec 1969

    Default formulating cross-product query

    I am a student taking my first database design course. I have to write an access query which I am stuck on. The statement has to include some calculations, it is based on a customer list. The calculations are: charge=service rate * fractional hours, charges must exceed average charges for all customers by 25%. Any suggestions on how to write this?

  2. #2
    Join Date
    Dec 1969

    Default Not Cross Product

    I&#039;m not exactly sure what you&#039;re trying to get from your explanation, but you don&#039;t want a "cross-product" or "cross join", if that&#039;s what you were thinking. <BR><BR>You know about the average function right, AVG()? You probably just need to use AVG(), Group By Customer, and then do some math.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts