unique number to display on Report

[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.

 

[Bill Mosca, MS Access MVP]

That should work on th ereport as well. Is it not?

 

[kingston via AccessMonster.com]

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.