Running Sum in Report Voucher number

[glen]

Hi all,

(1) I have a Report associated with one form.
I added one unbound text box there and put =1 in the source.and set running sum to Over group.
The problem is now that on first page of report it shows 1 and then in all pages it shows 2. Not incrementing to 3,4..........
(2) Secondly I use this Report for monthly closing.
So I want that if for january there are 10 pages of Report from 1 to 10.
Then when I make Report for Februay the voucher number should be start from 11............

[June7]

(1) Is the textbox in the group header/footer?

(2) How is the report to know it should start with 11?

Want to provide db so can analyze report design and the data?

[glen]

I am trying to attach my database but don't know what problem in file attachment that can't attach my file.

[June7]

Did you see instructions for attaching file at bottom of my post? What is the issue you encounter?

[glen]

Yes I know how and what file format to attach.But the problem was in my pc that it was not showing the add file and upload buttons on my attachment window.
I also clear all my cookies but still the same problem.
Now I try from other Pc so here working good the attachment window.

now I attached my database.
Please you check and give me your suggestions.
Thanks

[June7]

I open form and search for January 2012 records. The subform shows 11 records, most of them don't have data other than BlockNo. There is no GROUP designation in the report. I don't even understand what the RunningSum textbox in the Page header is basing its calc on. If you want RunningSum over a GROUP then need to define a GROUP. Use report Grouping & Sorting features. Put the textbox in a GROUP header or footer.

How should the report present this data? Should each record be on separate page? What is a single invoice? Why all the blank space in the Detail section?

For report to know what number to start with, must be data. Why is there no table for Invoice data?

[glen]

Thanks for your reply.
This is just a demo that's why I just put block numbers and left the other fields blanks.
This form is a continuous form where I will enter my data and the report will based upon this data.
if the rows of data in form is 100 then I want to show these 100 rows of records on Report in 10 pages.
each report page will contain 10 rows of records.
And I want a sequential number for these ten pages e.g 1,2,3,4...........10
And then when I enter records of February 2012 same number of records will be enter there and I want to print report it should start from 11 to 20.
Plz you do editing in my database according my needs and attach here.what ever you want to add or delete no problem.
It will be very easy for me to learn.
Thanks

[June7]

I am not going to build database for you.

Reports have a page number control (ignore the first section about page number in form, doesn't seem to be available in Access 2010) http://office.microsoft.com/en-us/ac...010096281.aspx

However, if you want each time report is generated it should start from a number other than 1, you will have to modify the report design to do that, regardless if you use RunningSum textbox or PageNumber control.

What you really need to do is properly design the database before even think about building forms and reports. To generate an invoice number need an Invoices table. You should explore database templates. The Northwind template is commonly used as a tutorial.

[glen]

Ok thanks for your suggestions.

Now I want to ask that I have two columns in form ID and Item.
Now when I create Report for these two items I want that to show these items in four columns in Report.
for example.
column 1
Id from 1 to 20
column 2
Items from 1 to 20.
column 3
again id continuous from 21 to 40
column 4
items from 21 to 4o.
Bcoz normally when I create Report in wizard mode it just show these two columns and the half page remain empty.
I put the id and items manually in the half page but don't know how to set it continuous.
bcoz this id is binded with table field id.
Thanks

[June7]

In report design, PageSetup tab on ribbon, try Column setup for PageLayout. Size the detail section so only 20 rows will fit. If that doesn't suit your needs then will probably need complex VBA code and temp table to produce the described output.

I never use the design wizards. They do things I don't like and make it harder to edit objects. As a for instance, all the controls are 'grouped' and can't be individually sized and moved. Select all controls, right click > Layout > Remove.

[glen]

This Problem is Solved. Thanks

[glen]

I noticed one problem now.
when I close the Report and re-open then it not showing the 2nd column.
then when I go in design mode and again go to preview mode then showing the 2nd column.
And secondly it not showing titles on 2nd column.

[June7]

I have only one report using column setup and I do remember it being a challenge. It has 4 fields that wrap into two 'columns'. I had to duplicate the 4 field labels for each 'column'. Labels are in PageHeader. By playing with font size, textbox height, margin settings, and space between columns, I get 116 records on 58 lines, plus 3 page header lines. Pretty much fills the sheet, allowing for 1/2 inch margins.

[glen]

Solved again.
Thanks again