Search results

  1. C

    Query On Query issue

    Haha, that's interesting cuz that is created by our teacher. If I create a table like you said, what field would I need? And what do you mean of the "use the foreign key from product to product category"?
  2. C

    Query On Query issue

    Not exactly. It is for the extra credit. And I have tried out three chances to get the full score. But I'm curious about the right answer.
  3. C

    Query On Query issue

    I guess your advise is available but according to the problem it need not a new table. Perhaps there is an another way. Thanks.
  4. C

    Query On Query issue

    Nobody knows how？
  5. C

    Query On Query issue

    The database is in the attachment. Problem decription: What I did is creating a query named offseasonrevenue to calculate the revenues meet the criteria and creating a query named wholesalerevenue to calculate all the revenue. For the final query, I used this equation to calculate the...
  6. C

    How to use Total->count to build these 2 query?

    Problem solved. It seems like the relation between those two tables have something to do with it. Your method is ok. Thank you.
  7. C

    How to use Total->count to build these 2 query?

    Thank you for the answer. The first one works, but the second one needs variables. Any other ideas?
  8. C

    How to use Total->count to build these 2 query?

    1. I have 2 tables that named [SHIPPING] and [TRANSACTION]. In the shipping table, there are transactionID and DateShipped fields; in the transaction table, there are transactionID, TransactionDate and Location fields. I want to create a query that counts all online orders(shows in the Location...
Back
Top Bottom