Weekly/Monthly Transaction Query

[Joe.Mobley]

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.

[PC Datasheet]

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
re******@pcdatasheet.com
www.pcdatasheet.com

<Jo********@nationalexpress.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

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.