Recent content by candy1

  1. C

    Flag first occurrence of the duplicate flagged as 1 and second occurrence flagged wit

    Thank you so much for your kind assistance.
  2. C

    Flag first occurrence of the duplicate flagged as 1 and second occurrence flagged wit

    Thank you so much for your response. Can I type the code in expression builder? Thank you for helping my novice self.
  3. C

    Flag first occurrence of the duplicate flagged as 1 and second occurrence flagged wit

    Thank you for your time. There is a date with time field such as 01/02/2016 13:01. Thank you
  4. C

    Flag first occurrence of the duplicate flagged as 1 and second occurrence flagged wit

    plog, Thank you for your time. Below is sample information. Could you be so kind as to let me know if the information is enough to assist? CuostimerID, Product, purchase date, combinedstring, unique, results AA77, bag, 1/2/2016, AA77bag1/2/2016, 1, original first encounter AA77, bag...
  5. C

    Flag first occurrence of the duplicate flagged as 1 and second occurrence flagged wit

    Jdraw thank you for the information and reference Truly appreciated
  6. C

    Flag first occurrence of the duplicate flagged as 1 and second occurrence flagged wit

    Thank you for your impute and assistance. The data at hand is the information that I currently have to work with and trying to analyze without deleting records
  7. C

    Hello

    Thanks Uncle
  8. C

    Flag first occurrence of the duplicate flagged as 1 and second occurrence flagged wit

    AA77, bag, 1/2/2016, AA77bag1/2/2016, 1, original first encounter AA77, bag, 1/2/2016, AA77bag1/2/2016, 0, duplicate encounter BB89, bag, 1/7/2016, BB89bag1/7/2016, 1, original first encounter AA77...
  9. C

    Flag first occurrence of the duplicate flagged as 1 and second occurrence flagged wit

    CuostimerID, Product, purchase date, combinedstring AA77, bag, 1/2/2016, AA77bag1/2/2016 BB89, bag, 1/7/2016, BB89bag1/7/2016 AA77, bag, 1/2/2016, AA77bag1/2/2016 AA77...
  10. C

    Flag first occurrence of the duplicate flagged as 1 and second occurrence flagged wit

    I am familiar with finding and identifying duplicate column in excel sheet using the formula below =IF(COUNTIF(A:A,A1)>1,0,1) with the first occurrence of the duplicate flagged as 1 and second occurrence flagged with 0 I am working in access database and would like to create similar field...
  11. C

    Hello

    I am a novice/minimal access user.
See more
Back
Top Bottom