Get some values and the inmediatly previous ones based on a date whithin a range...

[Odisea]

Hi everybody!

First of all, I didn't know how to search for the precise info regarding my question, so, If it is repeated, feel free to close this thread or delete it.

So, here it is my question:

I have a table with values taken once monthly, that is, for each person on that table, I would have a maximun 12 records per year. In that table I have the Id of the person, the date field where I store a date when I get the record, a field where I store a value and a control number field. The values on the control number field go from 1 to 20 (or less).

What I want to achieve is, given a range of dates, show the last two controls of every person, something like:
id, last control date, last control number, value of last control, previous control date, previous control number, value of previous control.
As you could see, I want to show in the same row the last two controls for each person, only if the happend to have two controls, if they have only one, it wouldn't be necessary to show them, so, how can I do this?.

Thanks in advance! .

 

[Jon K]

It's far too complicated for queries.

You'd be better off using VBA to update a temporary table.
.

 

[Cosmos75]

Maybe this can help get you started - Previous Date & Sum of Month/Year to-date using a correlated subquery