Compare data in the same database

[Panchovia]

How do you find the last record in a transaction table with acc of years of data of the year 2010 and the first record (or any other record) of the year 2011 in the same database to compare data.
structure transaction table query

clientno date amount reference

 

[MacroScope]

Just use a select query to sort all by date. Then do a DLast lookup with parameters looking at 2010, and a DFirst lookup for parameters looking at 2011.

 

[dhookom]

I don't trust First and/or Last in any query. Does your table have a primary key? If not, I wouldn't go further until one is added.

Duane
Hook'D on Access
MS Access MVP