Re: Report summing / table design question

Tech-Archive recommends: Fix windows errors by optimizing your registry

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,


"Joe C" <JoeC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E7496CA8-85F1-45FE-9913-C345FE9D0C17@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: Help With 3 Queries Please...
    ... Basically for the invoices question I want to user to open the query ... The user enters a booking ID ... the number of dogs boarded question even I don't have a clue ... I do have one final question: If I was to create a report based on ...
    (microsoft.public.access.queries)
  • Re: Report summing / table design question
    ... Dogs Cats Birds ... You could then use this query as the basis for your report. ...
    (microsoft.public.access.reports)
  • Re: Table to report design
    ... You already asked this in the REPORT newsgroup. ... dogs 100 ... dogs 250 cats 200 birds 300 ... Should I have different fields in the Table's design ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)