RE: [AccessDevelopers] Query question

Thu, 03 Nov 2005 06:57:11 -0800

To answer your second question, use DateAdd("m",6,dteYourDateField)
 
The "m" is for months, I might have the second and third arguments swapped, but you should be able to find DateAdd in the help file.
 
Tobi

From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Leeba
Sent: Thursday, November 03, 2005 3:24 AM
To: [email protected]; [email protected]
Subject: [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