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
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