unique number to display on Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a unique batch number which is an Autonumber. On the Form it has a
control source of =Date() & Format([BNS Batch no],"0"). This is so it
generates the current date along with the Autonumber e.g. 20/10/200601,
20/10/200602, 20/10/200603 etc. All I want to know is how to get this format
onto a Report I have created, otherwise only the number will show.
 
Create a text box in your report with the same formula. You have to include
the field [BNS Batch no] in the report if it isn't there already; you can
hide it or prevent it from printing if you feel that it's redundant. As an
aside, you probably already know that the date should be recorded somewhere
unless you intend for this document to be temporary only.
I have a unique batch number which is an Autonumber. On the Form it has a
control source of =Date() & Format([BNS Batch no],"0"). This is so it
generates the current date along with the Autonumber e.g. 20/10/200601,
20/10/200602, 20/10/200603 etc. All I want to know is how to get this format
onto a Report I have created, otherwise only the number will show.
Click to expand...
 
Back
Top