I deleted a couple of fields in a table since they contained calculated data.

Now I need to get that information in a query.

I want the query to use the value of a field in a post, with that of the same field in the previous post.

((field1 (of post nr 2)) - (field1 (of post nr 1)))

I quess there is a function for this, but I don´t know it.

Fuga.

[This message has been edited by Fuga (edited 04-09-2002).]