Re: Line Counter in report

You see, that is the problem with having to guess about information that was
not provided. You did read my statement that the two suggestions were based
on _guessing_ at the information you had not provided, didn't you. I am not
surprised that my guess was not correct -- as I implied before, answering
questions about Access is a strong point of this newsgroup; guessing at
missing information is that we have requested is not our strong point; but,
the information I requested (before and here) would be a good starting
point.

I still don't know what the underlying data tables are, what your Report's
RecordSource is, or what the Control Source is for each of these Controls on
the Report, so I cannot be of assistance. I'm sorry, but it it just not
possible to work entirely from what your Report output is. If you don't
provide more information, I doubt anyone here can help you (to do so they
would have to 'just happen' to guess correctly about the missing
information). Remember, you have the database in front of you, but we only
have what you write to go by.

Larry Linson
Microsoft Access MVP



"Mail Merge Help" <MailMergeHelp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C43E2985-F1C9-44C9-A824-537F303A8EE7@xxxxxxxxxxxxxxxx
Hi Larry

I have followed your suggestion in Point 1, it works but it start a new
line
number on every column, ie it doesn't continue the line number to the next
column. Any way to fix this?

I don't know how to work out your suggestion in point 2.

Thanks

"Larry Linson" wrote:

Examples of the output are nice, and helpful, but to help, we need to
know
what your data is in the tables and records... Do you have "Smith",
"Mason",
and "Bryce" all in one Record, or is each in a separate record?

From your description, it would seem that you have joined the Person and
related Books records, with a Join described as "All Records from the
Persons table and only those that match from the Books table" which
results
in a Record for the Person, whether there are any related Books or not,
thus
your problem. (And that the columns you describe are actual columns in
the
Report... defined in Print Layout.)

I can think of two ways to handle that:

(1) instead of the Query with a Join, make the Report based on the
Persons
Table, and the related Books information in a Subreport, with the counter
in
the Subreport. That way, if there's no book, there will not be a record
to
be counted.

(2) instead of placing the 1 in an unbound Field on the Form, create the
1
as a Calculated Field in the query when there is a book, bind that Field,
and set its Running Sum property.

If I've misunderstood, post back to clarify. If not, please post back to
confirm.

Larry Linson
Microsoft Access MVP


"Mail Merge Help" <MailMergeHelp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:A1E3D1BA-32F6-4306-900F-C46E88BD97B1@xxxxxxxxxxxxxxxx
Cheese, my example doesn't display properly.

On the head of each column is the surname , Smith in Column1, Mason in
Column 2 and Bryce in Column 3.

In details area, Smith doesn't have any book, Mason have bookA and
BookB,
and Bryce have book C.

At the moment, the running sum, show line 1 under Smith where there is
no
record, and line 2 for bookA, 3 for Book B, 4 for Book C.

What I want is for the number to start counting there is record, ie
start
1
from Book A under Mason surname.

Thanks

"Mail Merge Help" wrote:

Hi

Hi have a column report where I want to number the line. I've created
an
unbound textbox and used Running Sum= Over all. Which works fine.

My issue is that it also number the blank record of a column. ie, if
column
1 doesn't have any record, it will count as line 1, then column 2 have
3
records, the counting continue, ie 2, 3, 4, then column 3 is blank but
it's
still count as line 5.

I would appreciate any help on how to eliminate this problems, ie
don't
count line number for blank record.

Thanks





.

Relevant Pages

  • Re: Line Counter in report
    ... I have follow your previous suggestion in Point one where I created a report ... for Surname to have Smith, Mason and Victor on the Surname Header. ...
    (microsoft.public.access.reports)
  • Re: Line Counter in report
    ... I don't know how to work out your suggestion in point 2. ... In details area, Smith doesn't have any book, Mason have bookA and BookB, ... At the moment, the running sum, show line 1 under Smith where there is no ...
    (microsoft.public.access.reports)
  • Re: Line Counter in report
    ... following, so PLEASE copy the RecordSource of your Report, and if it is just ... for Surname to have Smith, Mason and Victor on the Surname Header. ...
    (microsoft.public.access.reports)
  • Re: Line Counter in report
    ... Column 2 and Bryce in Column 3. ... In details area, Smith doesn't have any book, Mason have bookA and BookB, ... At the moment, the running sum, show line 1 under Smith where there is no ...
    (microsoft.public.access.reports)
  • Re: Eliminate zero values/pass calculated value to new calc field
    ... In my report, I have a Calculated field that sums Beg.Balance and Deposit Amt, less fee amt and/or check amt. ... But then each successive period Ending Balance is off, because the calc still uses the original Beg.Balance amt. ... If there's too much detail here, you might at least consider using the "Running Sum" feature of an Access Report, though you can't do any calculations using it. ... The Queries listed here form the basis for a Report that lists individual transactions by date, running balance for the date, and ending balance. ...
    (microsoft.public.access.tablesdbdesign)