If logic question

[Guest]

im trying to do a slect query. i want to see how many loans were done each
month for each year. see below

county from 7/1/04 to 7/31/04 from 8/1/04 to 8/31/04
Adam 5 6
Bedfor 8 9

in my query im trying to say =Sum(IIf([PURCPT] between 7/1/2004 and
7/31/2004 And [LOAMAMT],1,0)) something like this can anyone help

 

[Duane Hookom]

You might want to use a crosstab query with a column heading of
"M" & Format([PURCPT],"mm")
Set County and Year([PURCPT]) as Row Headings.

 

[Guest]

In your query, convert all the date field to a date and year, i.e., 7/15/04
becomes 7/1/04. then run a group by on the new query field while counting
your unique identifier.

You might want to use a crosstab query with a column heading of
"M" & Format([PURCPT],"mm")
Set County and Year([PURCPT]) as Row Headings.
--
Duane Hookom
MS Access MVP
--

im trying to do a slect query. i want to see how many loans were done
each
month for each year. see below

county from 7/1/04 to 7/31/04 from 8/1/04 to 8/31/04
Adam 5 6
Bedfor 8 9

in my query im trying to say =Sum(IIf([PURCPT] between 7/1/2004 and
7/31/2004 And [LOAMAMT],1,0)) something like this can anyone help