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 Chriss Miller 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. Samait

    Excel 2000 GETPIVOTDATA With multiple fields

    i got it! I created new columns and used a formula like =a2&"1" to create new unique names for the second & third row fields. The problem was like this... GPPG: Industrial CGPPG: Industrial CIPPG: raw Getpivotdata couldn't figure out what industrial i wanted, so now it would be: GPPG...
  2. Samait

    Excel 2000 GETPIVOTDATA With multiple fields

    I've never used DGET before....here's the thing though, Every month I will be pulling more information from the pivot table, based upon the same criteria with only the month changing. Now, the report i am working on will have the data for Jan, Feb, Mar, etc... as the year moves on, so i have to...
  3. Samait

    Excel 2000 GETPIVOTDATA With multiple fields

    Hello. I think i have hit a brain block...i'm hoping you can help me. I am using Excel 2000 and need to get some things accomplished with GETPIVOTDATA. Here's the set up... Data value: AvgUnitCost Column Headers: Month... jan, feb, etc... Row Fields: GPPG (examples: Industrial, HWT, HWF)...
  4. Samait

    Desperatly seeking someones opinion

    Thanks you guys! I appreciate all of this information! I'll take all of this and develop from there. :-) I really really appreciate it!
  5. Samait

    Desperatly seeking someones opinion

    I agree with you on the downfall & production being in one table. As I look at it, i realize that this would best service the database. Thank you so much for your input!
  6. Samait

    Desperatly seeking someones opinion

    Tbl_Base could be compared to a table similar to Tbl_Invoice. My vision on this is as follows... The Tbl_Line holds the information regarding the names of the process lines. Wood is run through one of several process lines to come to a finished product. I have to report on the...
  7. Samait

    Desperatly seeking someones opinion

    Hello all! I have developed several databases but really seem to be drawing a blank here. My brain has frozen. I am trying to normalize a database i took over... Ok...after reading everything here and trying to apply it appropraitely, i have come up with the tables i show in the attachment, but...

Part and Inventory Search

Back
Top