[AccessDevelopers] Query question

II have a library database with the following query:

SELECT tblPaid.PaidID, tblPaid.NameID, tblPaid.AmountPaid, tblPaid.DateOfPAyment, [DateOfPAyment]+180 AS EndDate

FROM tblPaid

ORDER BY tblPaid.NameID, tblPaid.DateOfPAyment;

I want to get only the last record for each person as long as it is more than 15$. Basically, I need to know a list of the current memberships.

Also how can I change end Date to add 6 months. I did add 180 as that is almost 6 months.

Thanks for your help.

Leeba

Please zip all files prior to uploading to Files section.

YAHOO! GROUPS LINKS

Reply via email to