By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,254 Members | 2,386 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,254 IT Pros & Developers. It's quick & easy.

Total(Sum) between 2 dates

P: n/a
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
Nov 15 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Blue Lagoon Products - Customer Services"
<in**@bluelagoonproducts.comwrote in
news:IE*********************@fe2.news.blueyonder.c o.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

Nov 16 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.