Weekly/Monthly Transaction Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe.Mobley@nationalexpress.com - 22 Feb 2005 07:38 GMT

All,

In Microsoft Access when creating a query how do you enter a timeframe
for access to search between, as we need to search records by the week
on month, but we can only figure out how to search information on a
daily basis.

Once searched how do you total up the transations for that column not
for that row, as we can again only find a formula that adds up the row.

Reply to this Message

PC Datasheet - 22 Feb 2005 13:51 GMT

Rather than including your date field in your query, enter the following
expression in a blank field in your query:
TransWeek:DatePart("ww",[NameOfDateField)
Then if you want the transactions for weeks 1 to 12, put this expression in
the criteria:
Between 1 and 12

You can do a similar thing in another query for months:
TransMonth:DatePart("m",[NameOfDateField])
For months 1 to 3 use the criteria:
Between 1 And 3

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com

> All,
>
[quoted text clipped - 5 lines]
> Once searched how do you total up the transations for that column not
> for that row, as we can again only find a formula that adds up the row.

Reply to this Message