Results 1 to 4 of 4
  1. #1
    Join Date
    May 2012
    Posts
    2

    Post Customize Report X of Y

    Suppose i have a table with the following field and data

    item code :0025
    item name :XXXX


    date :01/04/2012
    grn No. :123
    nos of container : 5


    And i want to print report like

    item code : 0025
    item name : XXXX
    Date : 01/04/2012
    GRN No : PM 005
    Container : 1 of 5

    Next...............

    item code : 0025
    item name : XXXX
    Date : 01/04/2012
    GRN No : PM 005
    Container : 2 of 5

    Next.....................

    item code : 0025
    item name : XXXX
    Date : 01/04/2012
    GRN No : PM 005
    Container : 3 of 5

    and so on....................

    Thanks in Advance...............

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Sachin Bhai!

    The three records you put in your example are all identical to each other.
    Is that intentional? Is that how your data really is?

    Anyway, what you need in your report is a new field that will hold the 'Running Count'.

    1. Add a Text Box to the Detail section of your Report.
    2. In the Data Tab of the Property Sheet - put =(1) in the Coutrol Source row.
    3. In the Data Tab of the Property Sheet - put Over All in the Running Sum row.

    Now, when you run the report you will have a count of all the rows.
    You can tweak how it looks by adding a Label before that says "Container #: " and another Text Box after that has:
    ="of " & Count(*)
    in the Control Source.

    Hope this helps!

    Let us know if you need more help.

  3. #3
    Join Date
    May 2012
    Posts
    2
    Thanks For your reply,

    Now i am giving U more detail.

    Actually i am try to create one small utility for label printing for my company's store.
    suppose i receive 10 container of the same material in my store then i have affix approved like label on those container.
    till now we affix hand written, but i want to print from computer.

    All the field will be same on the label except container field.

    Suppose i have one form with the following field

    Item code :0025
    Item name :XXXX
    date :01/04/2012
    grn No. :123

    Total container Nos : 10

    so here i want that, there should be a button on the form,
    after filling all field, when we press that button , all these value should be save in table and
    generate 10 label/report with the following field

    item code : 0025
    item name : XXXX
    Date : 01/04/2012
    GRN No : PM 005
    Container : 1 of 10

    item code : 0025
    item name : XXXX
    Date : 01/04/2012
    GRN No : PM 005
    Container : 2 of 10
    .
    .
    .
    Container : 10 of 10


    and so on till 10

    All the field will be same on the label except container field.
    No of label depend on the no of container(if i receive 50 container then the no of label will be 50 )

    I hop this time i am able tell you my requirement.

    Any help will be appreciable.



  4. #4
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Hi Sachin,

    I think what you need is to create a Label Report.
    The following link will help with that:
    http://office.microsoft.com/en-us/ac...010007352.aspx

    Next, you have to come up with a way to get the '1 of 10', '2 of 10', '3 of 10' . . . into the text box on the label.
    Just thinking of it very quickly, I think you might have to write some VBA code to make this happen.
    Are you familiar with writing VBA Code?

    Since the data will only be in your database once for each 'shipment', you will have to provide a way for the label to print once for each container.
    You could:
    1. Create a Table to hold your Label data.
    2. Write code to put the data into your LabelTable - one row of data for each container - with a container number [1, 2, 3, . . .].
    3. Create your Label report so that one record appears on one label.

    Do what you can - and then let us know if you have questions.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Customize button "goto last record"
    By bertenbert in forum Forms
    Replies: 1
    Last Post: 12-30-2010, 08:38 AM
  2. Replies: 4
    Last Post: 12-13-2010, 05:33 PM
  3. Customize Message Box On Command
    By jpkeller55 in forum Access
    Replies: 3
    Last Post: 09-08-2010, 09:18 PM
  4. Replies: 2
    Last Post: 08-25-2010, 01:42 PM
  5. Replies: 3
    Last Post: 05-21-2010, 03:57 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums