Trouble with report

[Anon]

I am trying to make a report that calculates data from the current record and next record.
I have a table with two fields a auto_id and a number field. What I want is to run a select statement that will grab all data from this table. Then I want to return the value of the number field in a report along with the value of the number field minus the value of the next number field in the select statement.

hope this makes since

thanks

joe

[jeremy_brooks]

...so each subsequent value gets minused from the first value? Or only in pairs of two?

[Anon]

each value is subtacted from the previous value.

[[deleted]]

This would be a very complex query, especially because SQL has no 'next' and 'previous' records, just records that match a certain criterium.

I think the easiest way to get this data is to run a 'normal' query and process the records in PHP to get the extra information you need. In PHP you can easily declare a variable to contain the 'previous' or 'next' record.

[Anon]

How do you declare a variable to contain the value of the next record?

[jeremy_brooks]

well...you could put all of the values returned into an array, and use the logic $previous = $arr[$i-1], $current = $arr[$i], $next = $arr[$i+1]