Re: reports

From: Cheryl Fischer (cherylfischer_at_NOSPAMmsn.com)
Date: 04/29/04


Date: Thu, 29 Apr 2004 12:31:42 -0500

answered in: microsoft.public.access.gettingstarted

--
Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX
"Dave B" <davidbarton@bigfoot.com> wrote in message
news:hPakc.7$5h1.0@pathologist.blueyonder.net...
> Hi,
>
> How can i arrange the info that is populating my report in a decending
> order. The report shows payments made by a person in increment starting
from
> the initial amount to the last amount paid. The query that runs the report
> is set to decending within the 'sort' and when run display the info in the
> order i want(only within the query). Some how between that and the report
it
> swops round showing the last amount first rather than last.
>
> Thanks in advance,
>
> Dave
>
>
>
>


Relevant Pages

  • Re: Generate such a report
    ... The balances appearing in report are as ... How do I add a sum to a query you've made for me? ... payables in a table called "Settlements". ... Receivable By, Receivable From, and Amount. ...
    (microsoft.public.access.formscoding)
  • Re: Query Records and Detail Section of Report
    ... You say "a query that returns at least two records", ... deduct it from the [Amount of Claim] in the Nth record. ... LESS PREVIOUSLY PAID CLAIM textbox on the report, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Insert query result into form
    ... field/result on the report. ... unrelated queries. ... one based on each query. ... >> mode) and drag down the [Sum Of Amount] field? ...
    (microsoft.public.access.reports)
  • Re: Create sums on different groupings?
    ... You could base your main report on the group by and totals query I suggested ... by Name, date, and Amount. ... Then add this query to your report's record source so you have the 375" ...
    (microsoft.public.access.reports)
  • Re: Multiply Text Box
    ... You should not store ... >calculations in the query or a form or report based on the query. ... Amount], but does not have a field. ... My report needs to show Volume, ...
    (microsoft.public.access.gettingstarted)