John wrote:[color=blue]
> Hi Folks,
> I currently have a which I run on a databse of club member
> which gives me a total amount paid by each member in each calendar
> year...03,04,05 ect. The problem I have is that I need to specify specific
> dates between which I want to get the results. Is there a VBA line of code I
> need to add to the query or can I design a query which has the dates written
> in.I need it to be for the tax year April 4th to April 4th. Tia, John[/color]
In the query's QBE grid, in the criteria of the date column put:
BETWEEN #4/4/04# And #4/4/05#
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
