Recent content by jwbird46342

Using (PrevPts: DLookUp("Points","tblProgress","DateAdd('d', -1, [PtsDate])") kind of worked in that it's returning a number but it's the 1st record's points for every entry.

I'm very new to AccessWorld (actually my 1st post) so please forgive me if I'm not doing something exactly right in the forum. I'm keeping track of points by date and I'd like to have a query calculate the percentage as compared to the previous days (or previous entry's) points: Date Points...