1. The example above was built by a query from three different tables. Each record does not have a unique identifier. There is a unique identifier for each offender (OffNum), a unique identifier for each case number (CaseID) and a unique identifier for each PTRP # (PTRNum) on the underlying...
PTRP number data type is text.
The purpose is to determine the number of days between each violation (PTRP - which is an acronym for petition to revoke probation).
line1 is the first violation since the offender started the program, so the number of days is between the Induction Date in line1...
My apologies. That was an error. It should have (and now does) read PTRP date or Arrest Date (whichever is earliest). I also forgot to state that if the previous record has no Disposition Date, then it should read 0.
Name.........Case.....Induction..PTRP...PTRP.....A...
Hello. I am new to Access and looking for assistance with an issue. I had created a rudimentary database to track the violations of criminal offenders on a specific probation program. I was recently asked to determine the number of days between violations for each offender in the program, based...