Search results

  1. lwarren1968

    POWER QUERY UPCA CHECK DIGIT

    Can someone review the CheckDigit Calculation portion below? Something is off. Example 02636267000 returned check digit of 6 however it is actually 2 let Source = Excel.Workbook(File.Contents("J:\PRICE\QUERIES\144F\144F.xlsx"), null, true), Sheet1_Sheet =...
  2. lwarren1968

    Delete Rows between dates/times using an additional field to determine date/time range

    Can you attached the spreadsheet you were working with? Also, what happen to the 2nd "General Withdrawal"?
  3. lwarren1968

    Delete Rows between dates/times using an additional field to determine date/time range

    Yes, it is how I get the data. Regardless or maybe not it should not be deleted as it's within the date/time that should not be omitted.
  4. lwarren1968

    Delete Rows between dates/times using an additional field to determine date/time range

    Okay, its modified to show addition records after the end date. Also the time stamp is essential along with the date. Also, there should never be a 3rd "General Withdrawal".
  5. lwarren1968

    Delete Rows between dates/times using an additional field to determine date/time range

    I've edit it spreadsheet highlighting all in red that should be removed. Thank you.
  6. lwarren1968

    Delete Rows between dates/times using an additional field to determine date/time range

    all in red should be removed. Thanks. TimeZone Name Type 8/16/2023 6:13 AM PDT JOHN DOE 1 Express Checkout Payment 8/16/2023 7:23 AM PDT JOHN DOE 2 Express Checkout Payment 8/16/2023 9:33 AM PDT JOHN DOE 3 Payment Refund 8/16/2023 11:33 AM PDT JOHN DOE 4 Express Checkout Payment...
  7. lwarren1968

    Delete Rows between dates/times using an additional field to determine date/time range

    I need to delete rows between dates/times using an additional field to determine date/time range. Specifically, using the 1st "General Withdrawal" as the starting point under [Type] deleting all rows equal to or less then that date/time and then if there is a second "General Withdrawal" it...
  8. lwarren1968

    Solved sumif with 2

    Absolutely not. All has been helpful. I think I was in my head regarding how it should work vs how it actually works. Taking a second look this morning clarified the process. Thanks you.
  9. lwarren1968

    Solved sumif with 2

    Thank you so much. This works perfectly. I didn't think to put the calculation in first.
  10. lwarren1968

    Solved sumif with 2

    I honestly have been googling. I'm missing something, hence the reason I'm asking for help.
  11. lwarren1968

    Solved sumif with 2

    I'm getting an error "entered to few arguments for the function" =SUMIFS(Sheet1!A2:A1000, Sheet1!C2:C1000,"*01*",Sheet1!D2:166) LOC DATE Drawer CASH 001 03/23/23 00-507 0.00 001 03/23/23 00-768 0.00 001 03/23/23 00-WEB 0.00 001 03/23/23 01-013 719.58 001 03/23/23 01-014 460.90...
  12. lwarren1968

    Solved sumif with 2

    I'm not sure how to incorporate the AND(). I'm doing something wrong. Def. not an expert. =SUMIF(AND(Sheet1!A2:A1000,"*001*",Sheet1C2:C1000),Sheet1!D2:1000)
  13. lwarren1968

    Solved sumif with 2

    I am trying to include an "&" statement to look at 2 columns within my SUMIF statement, but it's not working. Works fine if I'm only including 1 column. Any advise? =SUMIF(Sheet1!A2:A1000,"*001*",Sheet1!D2:1000) I want to include an IF Sheet1!C2:A1000,*01*.
  14. lwarren1968

    SET WARNING TO OFF VBA

    no, append.
  15. lwarren1968

    SET WARNING TO OFF VBA

    I created a macro to turn off warnings (see below) and it works for me, however when someone else accesses the same data base they still receive the warnings. Please help. Private Sub cmdRunMakeTable_Click() DoCmd.Hourglass True Turns off the Access warning messages DoCmd.SetWarnings False...
  16. lwarren1968

    HOW TO TURN OFF VIOLATION ERROR WHE RUNNING A MACRO

    I'm not sure what I'm missing here? I have a macro that should run 3 queries upon opening the database and all warning have gone away accept the Violation error. How can I get this warning to stop as well? Option Compare Database '------------------------------------------------------------...
  17. lwarren1968

    Solved Subform/sub total update to parent table

    Thank you. It is finally working!
  18. lwarren1968

    Solved Subform/sub total update to parent table

    The total you are seeing is not related to my sub form. It's a one to many set up.
Top Bottom