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 strongm 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: npp83
  • Content: Threads
  • Order by date
  1. npp83

    CR 2008: Re Group

    Hey guys I have a problem but first, let me issue a few bits of background information to help you understand my report a little better. A preamble to my problem: I have two groups: G1)Branch G2) LoanOfficer. Both of these were created using Database fields and are not formula fields. Loan...
  2. npp83

    Return a blank for undesired value

    I have a series of date columns that are generating (on occasion) an un desired date (1900-01-01). I want to be able to isolate these dates per column and simply return a blank (' ') rather than a NULL or anything else. An example (partial) query I am using is currently this: + '|' +...
  3. npp83

    Rounding up decimal values < .5 to next whole value

    CR 2008 12.2 If I have an averaged value, calculated from a formula field that is less than the tradditional .5 barrier for rounding up, how can I round up the next whole number rather than rounding it down? For example, I have 0.33 and I want it to be 1.0 and not 0.0 Somehow, need to...
  4. npp83

    Adding an average by group

    Hi all, I posted previously on inserting averages into my report, and Lbass was kind enough to work with me through a solution to it. Building on that work, I now need to insert averages by my "Branch" group rather than by my Loan officer group. Please take a look at my website, which I have...
  5. npp83

    Averages of Running Total Fields

    I have performed a count on a column whose type is VarChar. The "string" this column is capturing is a GUID, which is alphanumeric, and can't be cast to an integer safely in order to perform an average on it. I want an average on the count, but the option isn't available for me to do so. Is it...

Part and Inventory Search

Back
Top