Search results

  1. W

    Conditional Calculation

    Thank you Mr. B! Final question, what would I do if I wanted a sum for everything that does not have an "x"?
  2. W

    Conditional Calculation

    I am looking for a excel formula to accomplish the following. Column A Column B $500 $750 X $100 X Can someone give me a formula that calculates the sum of Column A where there is an x in Column B?
  3. W

    SUM colums with matching criteria

    ACTION: Wet_Blanket slaps forehead! DOH! Thanks!
  4. W

    SUM colums with matching criteria

    Quick question, I have a spreadsheet with two columns: code value d $100 s $50 d $100 I want a formula that sums the total value column for rows where the code = "d". In this example, it would be...
  5. W

    Compacting creates Copy

    Thanks - Google worked: Issue: Access - Customer is trying to repair and compact his/her database and it creates a compacted db1.mdb file instead Cause: This is likely due to an upgrade to Office 2003 11.0_3 and all pertinent security patches and compatibility packs Resolution: The...
  6. W

    Compacting creates Copy

    Thanks Rabbie, good suggestion. I double checked my permissions and do have full permissions on the folder, so that isn't causing the issue.
  7. W

    Compacting creates Copy

    Greetings, Whenever I compact my database, it creates a compacted copy of the database (leaving the original database uncompacted). How do I correct this? Thanks, WB
  8. W

    Updating data in a linked table is not supported by this ISAM

    Anyone ever get this error? I have it currently when I try to update data in a linked table. Anyway to circumvent this? I believe I have done it before, but can't remember. Access 2003.
  9. W

    Formatting in a Query

    Wow, can't believe I didn't know about that function - actually I can. Here is the formula that works: acct_nbr: Format(Mid([table]![acct_num],7,6),"000000")
  10. W

    Formatting in a Query

    Got further, but having issue with the leading zero. acct_nbr: Right(Left([table]![acct_num],Len([table]![acct_num])-5),6)
  11. W

    Formatting in a Query

    I have an issue, I need to format a field from a table. the field is [acct_num], and the current format is this (bad I know): ### - ###### - ### or ### - ##### - ### I need to just have the middle 5 or 6 numbers for the query, drop off everything else. Plus, where the middle numbers...
  12. W

    Question Database needs to be repaired.......but

    Sorry for digging up an old thread. I decided to go with the following module to identify users logged into the database: Sub ShowUserRosterMultipleUsers() Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim i, j As Long Set cn = CurrentProject.Connection '...
  13. W

    Variable

    Thanks for all the help. I reached the conclusion that it was nonsense.
  14. W

    Variable

    You've found my true weakness....VBA.
  15. W

    Variable

    I didn't even have a true false in there (at least I didn't mean to).
  16. W

    Variable

    Its a whole mess. Let me explain. I need to edit a colum of names, to drop off part of the name. But in some instances, I don't need to do anything. Examples: Original Intended Result John and Joan Smith Smith Harold Buggy...
  17. W

    Variable

    Getting an error on this: =IF(iserror(search(“Pension” ,(E38),1)),E38,"")
  18. W

    Variable

    Brain, you are correct. What would you suggest?
  19. W

    Variable

    I tried the OR and got an error. I was thinking of doing another IF, but I can see that I will have to do a DLOOKUP (or VLOOKUP or HLOOKUP).
  20. W

    Variable

    =IF(SEARCH("Pension",(E38),1),E38,"") Worked like a charm. Riddle me this. What if there are a series of words I am looking for like: Pension Company 401k ? THanks for your help btw.
Back
Top Bottom