Please help me with this query

[hmho]

I have table that has this data below. Basically I would like to find the diffrence between the End_No for today and previous day. For example between 04/07/09 and 04/06/09 the diffrence for End_No is 50-40=10.
Please don't laugh I'm new to Access.
Thanks


Date G_No End_No

04/05/09 123 35
04/06/09 123 40
04/07/09 123 50

 

[Rabbie]

You should be able to do this using sub-queries. This link may be of some use.

 

[hmho]

I'm realy confuse can you give example.

Thanks

 

[ByteMyzer]

Something like the following (substituting highlighted text with actual table/field names):

SELECT T1.[B][I]Date[/I][/B], Min(T1.[B][I]End_No[/I][/B]) - (SELECT MAX(T2.[B][I]End_No[/I][/B])
                                  FROM [B][I]MyTable[/I][/B] AS T2
                                  WHERE T2.[B][I]Date[/I][/B] < T1.[B][I]Date[/I][/B]) AS End_No_Diff
FROM [B][I]MyTable[/I][/B] AS T1
GROUP BY T1.[B][I]Date[/I][/B];

 

[ByteMyzer]

Do I posr these in the query field or in the SQL?

Thanks

You post this in the SQL.