having trouble with report columns

  • Thread starter Thread starter Shannon
  • Start date Start date
S

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
 
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)
 
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


Shannon said:
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
Click to expand...


.
Click to expand...
 
Back
Top