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 Mike Lewis 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. Jowidog

    Access 2007 Table using a combo box lookup in a field

    Hey Doug, Sounds like you need an outer join query. However, are your tables normalized with a foreign key reference for lookups? There has to be some sort of connection between the two Parent to Child so you can form an outer join query without getting into the mess of a Union query which...
  2. Jowidog

    Missing data in MS Access 2007

    The reason ehaze is asking about field types is that MS Access does NOT like multi-value fields from external datasources for example if one of your fields in SP is an attachments type field, it does not translate well or come across unless you modify the way Access can handle the field...
  3. Jowidog

    Excel RANK error

    One other thing, in 2010 Rank is handled in to different way, one is Ran.EQ which works in the same wasy as RANK(). Assigning each value or rank a different ranking even if two scores are the same. What you may be looking for is Rank.AVG() which assigns rank for tied values. So iff two things...
  4. Jowidog

    Excel RANK error

    Is this the result you are seeing? 16.70 9.40 26.10 1 15.40 9.60 25.00 5 16.10 9.80 25.90 3 16.10 9.90 26.00 2 16.20 9.70 25.90 4 16.60 10.00 26.60 1 15.90 9.70 25.60 4 15.70 10.30 26.00 3 15.60 9.70 25.30 5 16.40 10.20 26.60 2 What is it that you are trying to clarify? Are you...
  5. Jowidog

    Suppressing #DIV/O! error in SharePoint 2007 calculated column

    Skip and Andy, I solved it thanks to both of your inputs: An old instructor once told me to "talk the formula through through out loud"....I am such a dunce. Here is the fix because the Current Equipment Count defaults to ZERO, the value is Zero and should be represnted as 0 (ZERO) and don't...
  6. Jowidog

    SharePoint 2007 Calculated field displaying #DIV/0! How to suppress

    PROBLEM SOLVED. An old instructor once told me to talk the formula through through out loud....I am such a dunce. Here is the fix because the Current Equipment Cound defaults to ZERO, the value is Zero and should be represnted as 0 (ZERO) and don't do a calculation if none of your friends are...
  7. Jowidog

    Suppressing #DIV/O! error in SharePoint 2007 calculated column

    Andy, Thanks! However the #DIV/0 error still shows: SharePoint List View 2007. Both fields are numbers so we are not mixing apples with oranges. Here is my syntax: =IF([Current Equipment Count]="",0,(IF(OR([Unit Strength]="",[Current Equipment Count]=""),0,ROUNDUP([Unit Strength]/[Current...
  8. Jowidog

    SharePoint 2007 Calculated field displaying #DIV/0! How to suppress

    Skip, I am still getting the DIV/0! error. SP accepts the syntax but I have two records that have Unit Strength ( number of people) that is greater than 0 (ths is true in all cases) but they may not have any items on hand. I recognize that we are trying to mask the divisor if no value is true...
  9. Jowidog

    SharePoint 2007 Calculated field displaying #DIV/0! How to suppress

    I will try your suggested change. It makes sense, however in the db there may be occasions where one or the other is blank (no value) or both may have values in the event of a contract renewal. I formed the above query in that way because of the situation in another calc column on subtracting...
  10. Jowidog

    SharePoint 2007 Calculated field displaying #DIV/0! How to suppress

    All, This should be very simple, but to be frank I am drawing a brain blank. I have two fields and I am trying to get a ratio. For the most part it works but if there is no value in Current Equipment, I get the famous #DIV/0! error that the command staff find a bit on the annoying side...
  11. Jowidog

    Suppressing #DIV/O! error in SharePoint 2007 calculated column

    All, I have a fairly straight foward issue. MS SharePoint 2007, view with calculated columns. I have a calculated column that has the following forumla =IF(OR([Field]=””,[field2]=””),0,ROUNDUP([field1]/[field2],0)) ISSUE: If Column 2 does not have a value then the dreaded #DIV/0! error shows...

Part and Inventory Search

Back
Top