Condensing Like Items in a Report

[LisaJohn via AccessMonster.com]

Hello-

I have created a table/ query with results in 1 category being the same i'd
like to take this information that is the same and condense it in a report.
Along with everything else. It is okay if the data from the other columns to
be missed. The condensing of like items is very important.

Please help!

Thanks!

 

[Duane Hookom]

Can you provide some sample data and desired output in the report? Your
question lacks specifics and clarity.

 

[LisaJohn via AccessMonster.com]

Sure.

Example below....

Name Billing Area July 09 Budget

Kress, Marc 4051 $60,002

Johnson, Mel 2223 $142,000

Kenty, Gon 4051 $23,000

Smith, Liam 4052 $56,666

*In this list there are two billing areas that are the same. Regardless of
the names involved i'd like to combine the two billing areas that are the
same for a combined budget total.

Thanks for your help!!

 

[Duane Hookom]

You can change your report's Record Source to a totals query with SQL like:

SELECT [Billing Area], Sum([July 09 Budget]) As Sum0709Bud
FROM [Your table or query name]
GROUP BY [Billing Area];

Do you really have a field containing a month and year?

 

[LisaJohn via AccessMonster.com]

Thanks so much!
Is there a way to get around to doing this without using SQL? I'm a little
unfamiliar as to the programming with that feature. If not i'll make a copy
of the db and play around with it. Just thought i'd ask.

You can change your report's Record Source to a totals query with SQL like:

SELECT [Billing Area], Sum([July 09 Budget]) As Sum0709Bud
FROM [Your table or query name]
GROUP BY [Billing Area];

Do you really have a field containing a month and year?

Sure.

[quoted text clipped - 15 lines]

Thanks for your help!!

 

[Duane Hookom]

You can do this in the query designer. Click the little sigma icon on the
tool bar and then set the appropriate properties for each column in the
query. You may want to remove columns such as the Name column.
--
Duane Hookom
Microsoft Access MVP

Thanks so much!
Is there a way to get around to doing this without using SQL? I'm a little
unfamiliar as to the programming with that feature. If not i'll make a copy
of the db and play around with it. Just thought i'd ask.

You can change your report's Record Source to a totals query with SQL like:

SELECT [Billing Area], Sum([July 09 Budget]) As Sum0709Bud
FROM [Your table or query name]
GROUP BY [Billing Area];

Do you really have a field containing a month and year?

Sure.

[quoted text clipped - 15 lines]

Thanks for your help!!