Search results

  1. 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...
  2. 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