Re: Table to report design

You already asked this in the REPORT newsgroup. Please stick to one post
per question. No need in two people investing time to research and respond
if the first answer is correct.

--
Rick B



"Joe C" <JoeC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FCF7B68C-B53C-4DA2-B0A8-A94C978C4D4C@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?
Thanks
JC papi


BTW How do I post to two groups, this one and the report design?


.

Relevant Pages

  • Re: ISE software bug???
    ... The design & report files attached below. ... TIMING REPORT ... Add Generic Clock Buffer: 8 ...
    (comp.arch.fpga)
  • Re: Date range on reports
    ... box to your report with a control source like: ... > In the Database window (Database window: The window that appears when you ... > In the New Form dialog box, click Design View, and click OK. ... > Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)
  • Re: Date range on reports
    ... Create an unbound form (unbound form or report: A form or report that isn't ... In the Database window (Database window: The window that appears when you ... In the New Form dialog box, click Design View, and click OK. ... Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)
  • RE: Multiply qty of filtered records
    ... If you should want to try doing this with a query (which is probably the more ... etc in the bottom part of the design view. ... I do know how to get this information in a Report, ... Dim rs As DAO.Recordset ...
    (microsoft.public.access.modulesdaovba)
  • Re: Date range on reports
    ... Without knowing where your report parameters were coming from, ... >>> open an Access database or an Access project. ... >>> In the New Form dialog box, click Design View, and click OK. ... >>> Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)