 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / March 2008How to create this report
I need a invoice report as below. Please inform how to do. INVOICE_NO ___________ DATE________ TO _______________________________ ___________________________________________________________ LINE_NO DESCRIPTION QTY UNIT PRICE TOTAL ___________________________________________________________ 1 XXXXXXXXXX XX XXXX XXXX 2 XXXXXXXXXX XX XXXX XXXX 3 XXXXXXXXXX XX XXXX XXXX 4 XXXXXXXXXX XX XXXX XXXX Open the Northwind sample database that installs with Access. Look at the Invoice report for an example of how to do it. You will need to understand how the data is stored in tables. The Invoices query combines the data from the tables to feed the report.  SignatureAllen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. >I need a invoice report as below. Please inform how to do. Mr. Allen, For more easiness for me I would like to know how to print according to line numbers. Please specifically tell me this. This is very important for me. Your great help will be a very big advantage for me. > Open the Northwind sample database that installs with Access. > Look at the Invoice report for an example of how to do it. [quoted text clipped - 3 lines] > > >I need a invoice report as below. Please inform how to do. In report design view, use the Sorting And Grouping dialog to choose the fields you want to sort by. If you want to sort the line items, in a particular order, you may need to add a field to the subform where you enter the line items. SignatureAllen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. > Mr. Allen, > For more easiness for me I would like to know how to print according to [quoted text clipped - 10 lines] >> >> > I need a invoice report as below. Please inform how to do. Ak, do you mean that you want each record in your list to be numbered? Evi > Mr. Allen, > For more easiness for me I would like to know how to print according to line [quoted text clipped - 13 lines] > > > > >I need a invoice report as below. Please inform how to do. Evi, Yes, I mean each record in my list to be numbered. This is the only problem I face. > Ak, do you mean that you want each record in your list to be numbered? > Evi [quoted text clipped - 18 lines] > > > > > > >I need a invoice report as below. Please inform how to do. Please help me. I need to know how can I get each record in my list numberwise, line by line. There are multiple invoices. How can I arrange this per invoice? > Ak, do you mean that you want each record in your list to be numbered? > Evi [quoted text clipped - 18 lines] > > > > > > >I need a invoice report as below. Please inform how to do. See if this does it. Put a text box in the section where you want the numbers to go. type =1 next to Control Source in the Properties box In the Properties box, choose Over Group next to Running Sum. If that isn't what you require, try 'Over All' Evi > Please help me. I need to know how can I get each record in my list > numberwise, line by line. There are multiple invoices. How can I arrange [quoted text clipped - 22 lines] > > > > > > > > >I need a invoice report as below. Please inform how to do. Dear experts, I have done my targeted work in probable success. Let me mention my report as it is. I believe you will get an idea about what I mean really. I got report as below. Instead of repeating LINE_NO of next invoice I need only invoice by invoice. For example for INV_NO.1 LINE_NO are 1 and 2. Other 1,2,3 and 4 are for 2nd Invoice. What to do to get this? Would appreciate your greate favor. If you want I will forward to you my report design. Please inform. INV_NO : 1 DATE : 10/2/08 TO : XXXXXX LINE_NO DESCRIPTION PRICE 1 PEN $2.00 2 PENCIL $5.00 1 CUTTER $2.00 2 RUBBER $6.00 3 STAPLER $9.00 4 clip $4.00 > See if this does it. Put a text box in the section where you want the > numbers to go. type [quoted text clipped - 33 lines] > > > > > > > > > > >I need a invoice report as below. Please inform how to do. If this is a simple report (and not a report with a subreport) then follow the instructions I gave for creating a Running Sum control and choose Over Group next to the Running Sum property. That will give you the line numbers Ensure that your report is grouped by eg Invoice number and choose Force New Page After Section in Properites while you are clicked on the InvoiceNumber Footer. Evi > Dear experts, > I have done my targeted work in probable success. Let me mention my report [quoted text clipped - 58 lines] > > > > > > > > > > > > >I need a invoice report as below. Please inform how to do. This is a report with a subreport because in table1 fields are : INV_NO DATE TO In table2 fields are : LINE_NO DESCRIPTION PRICE I need your instruction based on the above method. > If this is a simple report (and not a report with a subreport) then follow > the instructions I gave for creating a Running Sum control and choose Over [quoted text clipped - 72 lines] > > > > > > > > > > > > > > >I need a invoice report as below. Please inform how to do. I need such a way which is northwind invoice arranged. Per invoice corresponding line numbers. > If this is a simple report (and not a report with a subreport) then follow > the instructions I gave for creating a Running Sum control and choose Over [quoted text clipped - 72 lines] > > > > > > > > > > > > > > >I need a invoice report as below. Please inform how to do. The Northwind Invoice doesn't have a subreport. Where that invoice has ProductID, that is where you can put the running sum control as described. Make a copy of the Northwind Invoice and try it out. Evi > I need such a way which is northwind invoice arranged. Per invoice > corresponding line numbers. [quoted text clipped - 75 lines] > > > > > > > > > > > > > > > > >I need a invoice report as below. Please inform how to do. How can I total price in each invoice? Please comment. > The Northwind Invoice doesn't have a subreport. Where that invoice has > ProductID, that is where you can put the running sum control as described. [quoted text clipped - 93 lines] > > > > > > > > > > > > > > > > > > >I need a invoice report as below. Please inform how to do. Put a textbox into the Invoice footer and type into it =Sum([Price]) Evi > How can I total price in each invoice? Please comment. > [quoted text clipped - 95 lines] > > > > > > > > > > > > > > > > > > > > "ak" <akuttym@hotmail.com> wrote in message news:D2F6814E-7808-49AA-A9F3-434B616782EA@microsoft.com... > > > > > > > > > > >I need a invoice report as below. Please inform how to do. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.