unique number to display on Report

K

Kirt84

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Number sequences 0
Space at end of multi page list to accommodate new entries 1
Show week number in Project Report 0
Countdown macro - display settings 2
Display weeks from a Milestone 0
Autonumber 3
Publisher 2019 Format Picture window size too large to display OK button 0
Dealing with a Pivot Table (when I don't want to) 0

Top