Recent content by Adsmit

  1. A

    Calculating percentage change from previous records.

    Hi guys, Thanks for your help so far; Burrina, that's the sort of thing I'm after in the long run, but my main issue so far is trying to extract the second-to-last weight an animal gave. Glalaxiom, I tried your code (replacing the table name - my table is called tblWeights) but Access...
  2. A

    Calculating percentage change from previous records.

    Hi Plog - thanks for the reply! The issue I'm having now is that I receive a Type Mismatch in Expression error - initially I thought that this was because the date results in the second query displayed like 01-Sep-2013 for results from the Table and like 01/09/2013 for results from the query...
  3. A

    Calculating percentage change from previous records.

    Hi, I’m looking for a solution to the following problem. I have a table with the following fields; Row; AnimalID; Weight: Date_Weighed (see attached screenshot example). I would like to make a query that gives me the percentage weight loss/gain since the last time a particular animal...
Back
Top Bottom