Report summing / table design question

[Guest]

Hello,

I am looking to create a report down the road where sums of categories are
created.

I currently have a table with a field that is populated by a calculation in
a query. It is further categorized by an account. For example:

2 dogs 100
1 cats 200
3 birds 300
3 dogs 150

If on a report I need to see:

dogs 250 cats 200 birds 300

How would I do that? Should I have different fields in the Table's design or
in the Report's design?
JC papi

 

[George Nicholson]

Sounds like you can probably get the results you want from your current
setup by using a CrossTab query. Use AccountCategory (i.e., AnimalType) as
your column value and Sum of CalculatedField for Value (not sure what you
can use as a RowHeading, not enough information). It would give you a result
like:

(xxxx) Dogs Cats Birds
(????) 250 200 300

You could then use this query as the basis for your report. Note that (as
far as this query is concerned) Dogs, Cats & Birds are field names, making
it easy to place the results onto a report in a horizontal fashion if you
want.

Or,
in a report textbox use the following as the ControlSource:

= DSum("CalculatedFieldName", "Some Table or Query Name", "[Animal type
Category] = 'Dogs'")

Repeat as necessary.

HTH,

 

[Guest]

Thanks

Sounds like you can probably get the results you want from your current
setup by using a CrossTab query. Use AccountCategory (i.e., AnimalType) as
your column value and Sum of CalculatedField for Value (not sure what you
can use as a RowHeading, not enough information). It would give you a result
like:

(xxxx) Dogs Cats Birds
(????) 250 200 300

You could then use this query as the basis for your report. Note that (as
far as this query is concerned) Dogs, Cats & Birds are field names, making
it easy to place the results onto a report in a horizontal fashion if you
want.

Or,
in a report textbox use the following as the ControlSource:

= DSum("CalculatedFieldName", "Some Table or Query Name", "[Animal type
Category] = 'Dogs'")

Repeat as necessary.

HTH,

Hello,

I am looking to create a report down the road where sums of categories are
created.

I currently have a table with a field that is populated by a calculation
in
a query. It is further categorized by an account. For example:

2 dogs 100
1 cats 200
3 birds 300
3 dogs 150

If on a report I need to see:

dogs 250 cats 200 birds 300

How would I do that? Should I have different fields in the Table's design
or
in the Report's design?
JC papi