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!

  • Congratulations John Tel 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: hld24
  • Content: Threads
  • Order by date
  1. hld24

    Access 2003 - Matching Columns in same table

    I have one table with multiple columns and I need to bring back via a query all records that have matching data AND a Review By > 0 IE: S_Money = Money and S_APR = APR, etc. S_Money Money S_APR APR S_Income Income Reviewed by 50 50 7.8 7.8 40000 40000...
  2. hld24

    Crystal 10 Formula Help

    Adding a column on an already existing report and pulling the data from sheet 2 in Excel. Sheet 1 is where the rest of the information comes from. Group 1 Name = "Reviewed" and "Not Reviewed" (Sheet 1) Group 2 Name = State (Sheet 1) Detail Section includes: City, Tax and No Tax. (Sheet 1)...
  3. hld24

    IsNull formula help

    I am building a report that needs to look at a database and pull only the data that is incomplete. Incomplete is defined as being empty or "null". IE: I want to see all the reference numbers that have certain fields that are NOT filled out. There are twenty fields that should be filled out each...
  4. hld24

    Proper syntax for column adds and subtracts

    I have column A - Required Amount of Inventory Column C - Amount of Inventory ordered Column D - Amount of Inventory Received I am interested in Column E - Amount needed to be ordered. The first three columns are alrady on the report and are correct using Running totals. I need to take...
  5. hld24

    Running Totals Conditional Formula - Beginner

    Using Crystal 10 I am in the Running totals conditional formual screen. I am needing to add up all the apples that meet the conditions of "NF" and status of "IN Basket" OR "TREED". I am missing something as the "save and close" function kicks back the error: "The Remaining text does not appear...

Part and Inventory Search

Back
Top