having trouble with report columns

[Shannon]

I have a report of two months worth of dues pd for each
employee. Months are parameters to the report and I would
like the amounts for these two months to be shown in two
columns after the name column. I am retrieving two rows
instead - one for each month. My underlying table design
is:
MemID
Year
Month
AmtPd
DtPd
Dues/PensionFlag

Did I provide enough info???

Thanks much.
Shannon

 

[Duane Hookom]

You could set up columns in a totals query like:
FirstMth: Sum(Abs([Month]=[Enter First month]) * AmtPd)
SecondMth: Sum(Abs([Month]=[Enter Second month]) * AmtPd)

 

[shannon]

Could you give me a little more info...I made my query a
totals query, but now Access is requiring me to define an
aggregate function for each field on my query. I thought
perhaps I needed to create another query with just the
totals columns you provided, but this doesn't work. But
you probably knew that! How do I incorporate your code
into my existing query?

Thanks,
Shannon

-----Original Message-----
You could set up columns in a totals query like:
FirstMth: Sum(Abs([Month]=[Enter First month]) * AmtPd)
SecondMth: Sum(Abs([Month]=[Enter Second month]) * AmtPd)
--
Duane Hookom
MS Access MVP

I have a report of two months worth of dues pd for each
employee. Months are parameters to the report and I would
like the amounts for these two months to be shown in two
columns after the name column. I am retrieving two rows
instead - one for each month. My underlying table design
is:
MemID
Year
Month
AmtPd
DtPd
Dues/PensionFlag

Did I provide enough info???

Thanks much.
Shannon

.