Question on a report

[Xena11]

I have created a query that contains a data field and various data points. What I would like to do is to only show the records where the value changes in one of the data points. for instance I have a date and then a value of 700 this may be true for the next five dates until the value changes to 800. What I would like to show up in my query is only the date where the value changed and the changed value. I have tried to do this without successs. I know it will take an expression - but I need some suggestions on how to build it!



Thanks

[matthewspatrick]

Please post the SQL for your query as it is now.

[Xena11]

Here is the SQL for the report as it stands:


SELECT DISTINCTROW [Programmer columns].subjectid, [Programmer columns].therapy_date, [Programmer columns].amplitude, [Programmer columns].ontime, [Programmer columns].offtime, [Programmer columns].frequency, [Programmer columns].schedule_duration
FROM [Programmer columns]
GROUP BY [Programmer columns].subjectid, [Programmer columns].therapy_date, [Programmer columns].amplitude, [Programmer columns].ontime, [Programmer columns].offtime, [Programmer columns].frequency, [Programmer columns].schedule_duration
HAVING ((([Programmer columns].subjectid)="101-001"));