Re: Still I need to know how

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

To put your invoice number on your other pages, as well as in the invoice
header, put a text box into the group footer and type
=Inv_No
Evi

"ak" <akuttym@xxxxxxxxxxx> wrote in message
news:4396347C-6676-4D23-A1B1-DD1D8D2355E2@xxxxxxxxxxxxxxxx
I could follow your explanation successfully. Now line number
is ok. I need some more favor.

INVOICE NO:
I need invoice number in 2nd page
of invoice. For invoice no.1 in case there is 3 pages need in all pages
I need the no.1 in page 1, 2 and 3.
For invoice no.2 in case there is 2 pages I need invoice no.2 in page
1 and page 2.

PAGE NO:
My report has page numbers in footer. But I am not getting page number
per
INVOICE as group. In case Invoice no.1 has 2 pages and Invoice 2 has 3
pages I get page numbers as below:
Invoice No.1 : Page 1 and 2
Invoice No.2 : Page 3 and 5 etc....

Please comment.



"Evi" wrote:

OK ak. Some of the things I am telling you, you will already know.
But just in case you have missed something out.....
You need to have 1 field which is always different each record. With
invoices this is usually the invoice number.

From the look of your results, you have already used the
Sorting/Grouping
box to group by Invoice Number and you have your Invoice Number and the
date
in the Group Header

If this is true then check if you also have a Group Footer It may be
called
Inv_No Footer if your field is called Inv_No
If not:
Click on the Sorting/Grouping box on the toolbar.
Choose your Invoice Number field in the list.
Where it says Group Footer, choose Yes.

Close the Sorting/Grouping box
Click on the grey bar which has the name of your footer (perhaps Inv_No
Footer)
Click Properties
Click on the Format tab
Next to where it says Force New Page, choose After Section.
Does this do what you want?
Evi



"ak" <akuttym@xxxxxxxxxxx> wrote in message
news:A28D3082-A300-4782-9802-DA2996E96077@xxxxxxxxxxxxxxxx
Dear Evi,
I want to see 1 invoice at a time. I dont want to see each invoie on
a
different page as I have now. There is no issue about word
"DESCRIPTION".
I
know those
kind of tricks. Please comment.

"Evi" wrote:

That's great, it looks like you have successfully added a Counter
control
Do you mean that you only want to see 1 invoice at a time or that
you
want
to see each invoice on a different page?
If you just mean that you don't want to see the word Description
then
click
on that control in the report's Design view and delete it.
Evi

"ak" <akuttym@xxxxxxxxxxx> wrote in message
news:4FF9EE8D-962B-4618-AE9E-5F06717C9CA9@xxxxxxxxxxxxxxxx
I have done as you told me. Let me tell you how my report can see
now.
I dont want three invoices's description as below.

INV_NO : 1 Date:10/2/2008
TO : ABC COMPANY
_______________________
S# DESCRIPTION
--------------------------------

1 CUTTER 10.00
2 PENCIL 5.00
3 PEN 2.00


1 PAPER CLIP 4.00
2 RUBBER 3.00
3 STAPLER 8.00
4 PIN 6.00


1 PENCIL 2.00

Evi" wrote:

I see the problem. The word Control means (partly) anything that
you
put
in
a report or a form in Design view - lines, fields, text boxes,
labels,
check
boxes etc.
Am I right? You have put in a text box called Line_No?
*This should not be a field in your Query*, just a text box
which
you
drew
there.
When you first put the text box in your report, it will have the
word
(Unbound) written in it.
Type
=1
in it.
(this is the same as typing =1 in the Control Source)
When the Properties box is open, click on the tab that says
Data.
One of the lines there will be labelled Control Source.
It should have =1 typed next to it.
Just below that in the Properties box is a line labelled
Running Sum

Click in that and you will see a down-arrow. Here you can choose
Over
Group.

There is an example of one of these Running Sum controls in the
Detail
section of the Sales By Year report in North Wind

Now, as for the Northwind Invoice report, this doesn't have line
numbers
in
it. The field that looks like Line Numbers is a field in the
table
called
Product ID. You will see that if (on a copy of Northwind) you
delete
one
of
the products, there will now be a gap in the Line numbers - they
won't
be
consecutive (1, 2, 3, 4 etc) but may say something like 2, 4, 7
etc.



Please ask if any of this is unclear.

Evi.






"ak" <akuttym@xxxxxxxxxxx> wrote in message
news:22DE91CD-BF69-4DB9-AFC4-8B065DBD2921@xxxxxxxxxxxxxxxx
I need line number in detail section. I cant see control
source
there. In
details section I have a field called "LINE_NO" . In this
field I
right
clicked to go to properties. I could not see control source
there.
Where
can I go ?

"Evi" wrote:

If you look back you will see that Alan and I and others
have
done
our
best
to answer your questions and each string of messages has
ended
with
you
NOT
replying to say which bits of our messages you don't
understand.
I will quote the reply I gave earlier to this same question.
Please
be
kind
enough to read it and then tell me which bit of my reply you
don't
understand.
How to create Line Numbers:

Put a text box in the section where you want the line
numbers to
go.
Type
=1
next to Control Source in the Properties box
In the Properties box, choose Over Group next to Running
Sum.
Does this give you the results you want?


It is not reasonable to expect anyone to spend the time to
write
a
long,
detailed explanation in a newsgroup when you haven't asked a
specific
question. There are many Internet Sites (and even books
which
you
can
buy)
which give details of Access for beginners. You only need to
use
Google
to
find them.
But the newsgroups are there to answer specific questions.
For instance, if you didn't understand how to use the
sorting
and
grouping
box, or what the Properties box is, it would not be
reasonable
to
expect
anyone to spend the time writing a detailed explanation
because
you
can't be
bothered to ask the question.
However, few of us will begrudge giving you this explanation
if
you
just
say
that you don't understand that.
I do understand that it must be very difficult to ask
questions
in a
non-native language but please persevere.
Read our replies. Quote the bit you don't understand and we
will
do
our
best
to clarify it.
Evi


"ak" <akuttym@xxxxxxxxxxx> wrote in message
news:EAEEDDF4-07C6-4A0A-A9CC-217D97B83851@xxxxxxxxxxxxxxxx
Please help me to know how can I find out that northwind
invoice
creation.
Specifically how that line number is coming in the
invoice.
Why
that
is
not
main
form and sub form. If it is not main form and sub form
how
come
change
its
invoice number for each invoice. How to arrange this? I
need
a
very
clear
and detailed explanation from you please. I am struggling
for
this
for
long
time.
Nobody is educating me proper way.















.

Relevant Pages

  • Re: Still I need to know how
    ... I want to see 1 invoice at a time. ... "Evi" wrote: ... One of the lines there will be labelled Control Source. ... If it is not main form and sub form how come ...
    (microsoft.public.access.reports)
  • Re: Still I need to know how
    ... In the Sorting/Grouping Box, click next to Inv_No ... One of the lines says Group Footer ... Repeat Section to Yes in Properties for your Invoice Number header. ... Thanks in advance Evi. ...
    (microsoft.public.access.reports)
  • Re: Still I need to know how
    ... Have you tried putting the Invoice Number in the Page Header? ... "Evi" wrote: ... One of the lines says Group Footer ...
    (microsoft.public.access.reports)
  • Re: Still I need to know how
    ... Invoice No.1 there are two pages. ... Thanks in advance Evi. ... put a text box into the group footer and type ... If it is not main form and sub form ...
    (microsoft.public.access.reports)
  • Re: Printing sections of reports at set locations
    ... the pre-printed form. ... > Invoice ID group footer. ... but presumably each invoice starts on a new page. ... You will also have an InvoiceID group footer. ...
    (microsoft.public.access.reports)