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.