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: *

  • Users: hallmg
  • Content: Threads
  • Order by date
  1. hallmg

    Rounding yields only zeros...

    Crystal XI. Have these fields/formulas to calculate the number of rooms required for a building with a particular capacity: CAPACITY @MaxCapacity = CAPACITY * 0.95 @Rooms = @MaxCapacity / 15 @TotalArea = @Rooms * 60 And Group sum totals for each placed in the Group Footer. ...which all seems...
  2. hallmg

    Current quantity for last transaction date?

    I'm having a hard time figuring this out, so any help would be appreciated. I have these tables: Inventory - Item#, description, category Inventory_by_location - Item#, DATE (inventoried), Site, Bin, Qty History - Item#, TranDate, qty change on that date All tables are linked by the Item#...
  3. hallmg

    Selecting records on third field away...

    Using CR XI Oracle 10g Two tables linked on group: N0 (employee data) empid group reportsto (empid of the person this record reports to) G0 (org data) group orgcode The orgcode keeps the group heirarchy and is formatted as 01010100000000 where each two characters is a level in the...

Part and Inventory Search

Back
Top