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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. brounea

    Pivoting table ??

    Duan, I tried it and the problem is even harder. I do not know how to put the sum(qty) under the right month. In other words: The cross tab gives me the sum(qty) in the right month. The months heading is just the heading. When a row of data comes, how do I put the right...
  2. brounea

    Pivoting table ??

    Thanks Duan, I'll give it a try. -A
  3. brounea

    Pivoting table ??

    Thanks Duane, That does solve the dates heading issue. Could you explaing, what do I need to do for the sum(qty)? What would the query look like? I realy appriciate it. Thanks again -A
  4. brounea

    Pivoting table ??

    Thanks Crowley16 But I would hope that there is a better way. I was looking into Crosstab tables. Can anybody give me some more info. Thanks
  5. brounea

    Pivoting table ??

    As you can see I'm new here and new to Ms Access. Here is my question. I'm trying to write MS access report that looks like this: Item Subinventory JAn-04 Feb-04 Mar-04 ... 123 DC sum(qty) Sum(qty) sum(qty) 123 DE sum(qty) 0...

Part and Inventory Search

Back
Top