asked on Need your help with Query in access
Rec# LookUpDate Amount1 Amount2
58 9/23/2013 72,599.00 33,795.00
59 10/23/2013 75,753.00 35,063.00
60 11/8/2013 75,046.00 35,063.00
61 12/9/2013 78,256.00 35,700.00
62 1/8/2014 80,615.00 36,340.00
twice a month, i input two amounts :Amount1 and Amount2 in the database,
how to write a query to see the difference in last and previous records, in case like this should be:
RecentDate Diff1 Diff1
1/8/2014 2,359.00 640.00
58 9/23/2013 72,599.00 33,795.00
59 10/23/2013 75,753.00 35,063.00
60 11/8/2013 75,046.00 35,063.00
61 12/9/2013 78,256.00 35,700.00
62 1/8/2014 80,615.00 36,340.00
twice a month, i input two amounts :Amount1 and Amount2 in the database,
how to write a query to see the difference in last and previous records, in case like this should be:
RecentDate Diff1 Diff1
1/8/2014 2,359.00 640.00
Microsoft AccessSQL
Last Comment
Shaun Kline
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.