Compare each record with previous

[Risto85]

Hi,

Is it possible to add a field into query where it checks specific field in each record with previous record? In case they are same then 0 should be displayed, if different then 1 should be displayed.

[NTC]

yes but it is an advanced design. in a database there is no such thing as 'previous' inherently there must be a field which is sequential and then one can join a table on itself - modifying the join with manual sql to be:
table.ID=table.ID-1

this will result in record set where those 2 rows now have fields all in the same row - and so you can then do calculated fields.