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!

Recent content by jhaganjr

  1. jhaganjr

    Excel PivotTable calculation

    You're dead on again, Skip. But formulas outside the PT are rendered useless as soon as filter options change the layout of the PT results. I just don't think I can get the best of all worlds ... the flexibility of the PT PLUS the power of complex functions. I appreciate your help.
  2. jhaganjr

    Excel PivotTable calculation

    Skip, I use those functions now. How does one use those in a PivotTable? As far as I can tell PT's do not provide that kind of formula insertion ... so that I can utilize the PT flexibility, while also getting the analysis from the functions you suggested. Is it possible? Thanks, again.
  3. jhaganjr

    Excel PivotTable calculation

    Sorry ... don't know how to attach a file. The 8 cell example is really exactly the source data to work with. Goal stated in words ... which I can do outside a PivotTable ... but trying to take advantage of PT flexibility ... Count all the lead records Count only the sold results Show me the...
  4. jhaganjr

    Excel PivotTable calculation

    Simple data setup ... each record is a sales lead. Each record includes a result column - sold or unsold. Simple example might look like ... Lead Result 6/1/10 Open 6/2/10 Sold 6/3/10 Sold 6/4/10 Unsold I would like a "report" result like this ... CountOfLead...
  5. jhaganjr

    Short SQL to duplicate record?

    Thanks Remou. That's over my head just looking at it, but I can play with it to see what happens. Then I'll understand it.
  6. jhaganjr

    Short SQL to duplicate record?

    Yes. That helps. At least it cuts the typing in half. I only I have to type the field list in once instead of twice. Thanks!
  7. jhaganjr

    Short SQL to duplicate record?

    I want to duplicate a record in the same table - all the data except the key field, of course. The append query is easy enough. For example, here I am duplicating record #2 in my test table called zzTblJunk: INSERT INTO zzTblJunk ( Field1, Field2, Field3 ) SELECT zzTblJunk.Field1...
  8. jhaganjr

    speed up delete where value not in multiple tables

    Your explanations make perfect sense. And I know from putting your solution into practice it works fantastically. My indexes were already in place, but I did add the "Top 1" syntax to speed things up even further. Thanks, again. I learned a lot from your posts! Joe
  9. jhaganjr

    speed up delete where value not in multiple tables

    Golom, Thanks for the code. I like it, and will be able to use it in other settings. Joe
  10. jhaganjr

    speed up delete where value not in multiple tables

    My thoughts WERE (when I first read it) ... I understand the goal, but how does what you wrote achieve it? Still, I plugged it into my live data, and it works. Thanks a million! I'm still trying to get my amateur brain around why it works. It seems like a "double-negative" ... looking for...
  11. jhaganjr

    speed up delete where value not in multiple tables

    Hello Amazingly Smart People, I did a search and found the answer to my question. However, the answer is excessively slow. I'm wondering if you know a better way. Need: To delete records from TblA when the key value of the records does not appear in several related tables. Solution: DELETE *...
  12. jhaganjr

    Get list from same data field in separate tables

    That's it. Thanks very much. Simple, but unknown to me. Thanks again, Joe
  13. jhaganjr

    Get list from same data field in separate tables

    This seems like it should be simple, but for some reason it's not (for me) ... Table1: RecID Client 1 A 2 B 3 C Table2: RecID Client 1 D 2 A 3 E As you can see Client A appears in both tables, but the other clients do not. How do I query the Client value...
  14. jhaganjr

    Force rows into a query ...

    Thanks Jerry, As it turns out, when I took Duane's ideas to the real situation I realized that there will always be some kind of sale in any month. Therefore, the cartesian query that sets up the agent and month combinations does not filter for type of sale. That way I'm guaranteed to always...
  15. jhaganjr

    Force rows into a query ...

    That's great, Duane. Thanks! I can tweak that to the reality of my situation. Now ... what if there aren't sales in every month? In that case the cartesian query cannot include that month, and so I will have a missing month for each agent instead of a zero month for each agent. In reality...
See more

Part and Inventory Search

Back
Top