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 Rhinorhino 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. RedBean

    Running total of another running total

    Thanks a lot for the help! It worked great. I know that my request seemed a bit strange, but the data I am working with is incomplete and this was the only way I knew that would get me the results I needed. Thanks again.
  2. RedBean

    Running total of another running total

    I have orders that contain varying number of items. The majority of the items will have the same quantity, that is the number I am interested in for each order. So I group by order and do a running total with Nth most frequent with N = 1. Now there are various types of orders and I need a sum...
  3. RedBean

    Query Join Help

    Thank you very much, nsukari. Your solution worked great!
  4. RedBean

    Query Join Help

    I have a table in the following format: REGION REP# NAME STATE SALES A 0031 Joe MA $10,000 A 0302 Mary CA $15,000 A 0063 Mike TX $15,000 B 0004 Bob NY $7,000 ... What I want to do is return for every region the person with the highest Sales...
  5. RedBean

    [ACCESS]

    Thanks for the replies, guys. I am going to use arb4's solution since it runs much faster. I am so glad I stumbled upon this forum, you guys are the greatest.
  6. RedBean

    [ACCESS]

    Hi, I have two tables the first one contains the history of book sales and looks something like this: CUST# BOOK# QTY 12345 A9999 1 12345 B0001 2 98765 A9999 5 99999 C0009 2 ... The second table just contains a subset of books that I am interested in, like: BOOK#...
  7. RedBean

    [EXCEL] referencing a cell's value AND format

    Is there a way to reference both another cell's value and formatting? I have 2 sheets, one with book numbers and their current status and the other with orders. I have the orders sheet perform a vlookup on the book number on the book number page. While this gives me the current status of the...
  8. RedBean

    Subtotals with one-to-many link

    Thanks, dgillz you really are the greatest. :) That was simple enough. I could have sworn I already tried that, but I guess not. Thanks again to everyone on this board, most helpful place I have ever been to.
  9. RedBean

    Subtotals with one-to-many link

    Let me see if I can explain this a bit better. Right now I have a report which has a one-to-many link, so pretty much several records would have all the same information except for the Credits field. (I just realized the example in my first post was not correct, this one is more of what it...
  10. RedBean

    Subtotals with one-to-many link

    I tried to do that, but it would sum up the duplicates that show up. I just want to sum up the amount once for those invoices that are duplicated because of the one to many relationship. Doing it the way dgillz suggested seemed to have resolved the duplicate problem. Is there a way to use a...
  11. RedBean

    Subtotals with one-to-many link

    Well, I am looking to have a breakdown on the amount for H status items and those that are anything but H. If I understood what you suggested that would give me a total amount for all regardless of status. If I misunderstood your post, can you please rephase it in a different way? Thanks for...
  12. RedBean

    Subtotals with one-to-many link

    Hi, I have two tables linked in a one-to-many fashion. One contains the Order#, Amount, and Status and the other contains Credits among other things. It looks something like this: Order# Invoice Amount Status Credits 1 A $10 H $1 1...
  13. RedBean

    Grand Total including all groups

    dgillz: I followed what you said in the other message and it worked perfectly. I entered the formula into the group selection window. The thing was even after doing that, the grand total at the end was the same as before the selection. So I tried to choose records meeting a different criteria...
  14. RedBean

    Grand Total including all groups

    Hi, I used dgillz solution to my previous problem (thread767-319175 and that worked great. The problem now is that my grand total at the end of the report includes all the groups, even the ones that were filtered out with the group selection formula. I just want to sum up a total for the...
  15. RedBean

    Show entire group if one record matches

    thanks for the help, dgillz
  16. RedBean

    Show entire group if one record matches

    Hi, I was wondering if the experts here can help me with a problem I am having. I have 2 tables, one with order numbers, order dates, custumers, etc. It is linked to another table by order number that contains the specifics of that order, i.e. the specific item, price, etc. There is one field...

Part and Inventory Search

Back
Top