Total(Sum) between 2 dates

[Blue Lagoon Products - Customer Services]

Hi,

I am in a bit of a pickle...I need to know the Total figure of the gross
field in my table between 2 dates specified in a query.

I need to know what criteria to put into my query on the gross field (my
system uses short dates, 06 not 2006 if that makes any difference)

The total will be displayed in a form and also in a report

--

Thank You,

Nick Jones

[Bob Quintal]

"Blue Lagoon Products - Customer Services"
<in**@bluelagoo nproducts.comwr ote in
news:IE******** *************@f e2.news.blueyon der.co.uk:

Hi,

I am in a bit of a pickle...I need to know the Total figure of
the gross field in my table between 2 dates specified in a
query.

I need to know what criteria to put into my query on the gross
field (my system uses short dates, 06 not 2006 if that makes
any difference)

The total will be displayed in a form and also in a report

whatever the format dates are displayed in, Access stores them
the same way (as the number of days since 12/31/1899).

To successfully create your query, open the parameters dialog in
the query, and create two parameters: start date, end date, and
assign them both to datatypetype date/time.

or you could type
PARAMETERS [start date] DateTime, [end date] DateTime;
as the first line of the query in SQL view.
The criteria would be Between [Start Date] AND [End Date]
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com