Results 1 to 1 of 1

Thread: Invoice Peoblem

  1. #1
    Join Date
    Aug 2003
    Posts
    160

    Unanswered: Invoice Peoblem

    Hi!

    I have DeliveriInformationTable which includes fields

    DeliveryAgreement#(PK)
    DeliveryDate
    DeliveryCharges
    HandlingCharges
    TotalInvoiceAmout

    CompanyInformationTable

    CompaneName
    Address
    City
    State
    Zip
    Phone

    Here I made a report from a query form the above two tables which includes all the fields. Which is a parameter query, with parameter as DeliveryDate.

    Here My problem was I don't know how to get a Invoice# on the report for that Deliverydate Which is sequential and starts at 20040000 today.If the delivery date is tomorrow I want next invoice# to be 20040001.If the year is 2005 I want the Invoice number to be start at 20050000. Even If there is a gap between the dates I want the sequential Invoice#'s

    Is it possible to get.

    Actually report is based on a parameter query.It promts for Dilivery date.Whenever we enter the same date the Invoice# must be the same.

    Any Help!
    Thanks
    Last edited by vad; 01-29-04 at 12:35.
    Vad

Posting Permissions

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