Results 1 to 9 of 9

Thread: Invoices (2003)

  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Invoices (2003)

    Some time ago, I had help creating multiple page invoice reports <post#=574,461>post 574,461</post#>. What I needed to do, and did, was to put multiple Invoice numbers on one sheet, which shared the same customer order. Our customers didn't want multiple invoice numbers, just the one. so the first Invoice number was used layed out like this:-

    Invoice No.21920
    21920 order details
    21935 order details
    22006 order details.

    I've just been told, that sometimes, the invoice number doesn't relate to any of the others to that order. Eg.

    I nvoice No.21935
    21920 order details
    21935 order details
    22006 order details.

    It doesn't happen all the time apparently, only sometimes. I use the expression =Concat("tblInvoices","code","orderno =" & Chr(34) & [Orderno] & Chr(34)), in the control for the main invoice no. Is there something I should be looking for?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Invoices (2003)

    I don't see where the Concat function is used in the examples you provide - nothing is concatenated.

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Invoices (2003)

    In the full report, we have customer purchase order, so concatenate puts the Invoices in order with the purchase orders. So at the side of my examples all lines would say something like 4256658.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Invoices (2003)

    I'm sorry, I don't have the slightest idea what you're doing or what you want.

  5. #5
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Invoices (2003)

    The concat expression in Invoice number in this image, puts all Invoices related to the PO number (highlighted Yellow), on the same page. The Items highlighted Red, should be the same, as they are in this image
    Attached Images Attached Images

  6. #6
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Invoices (2003)

    In this one they're different. This is what I can't work out, as it doesn't happen all the time
    Attached Images Attached Images

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Invoices (2003)

    This doesn't appear to have anything to do with Concat. Please post a stripped down and zipped copy of the database. See <post#=401925>post 401925</post#> for instructions.

  8. #8
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Invoices (2003)

    In the full database, a form opens on startup, where the user enters the first range of invoice numbers. This runs a make table query, which contains all the invoices in that range. Because not all invoices may be sent, another form opens up (frmSelect), so the user can select the relevant invoices. On clicking OK, the report is run (rptInvoice2). I've run the report, and this time, it did what it should do, so I can't see what's wrong. But as you can see from the image I posted, somethings wrong. Perhaps you can suggest a better method for the report. For the this run, you need to select the following invoice numbers on the select form:-
    I21956, I21925, I21928, I21920, I21950, I21951, I21953, 21967, I21968, I21969 & I21992
    Attached Files Attached Files

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Invoices (2003)

    I think the problem is that the text box Text80 displays a series of invoice numbers (as the result of the Concat function) but it is so small that there is only room for one invoice number.
    You should make the text box wider, and either make it high enough to accomodate the invoice numbers or set its Can Grow property to Yes and leave some space below it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •