Autonumber + Report

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

Guest

I am creating a database to track art generated for manuals. Each piece of art should have a unique number (NO duplicates), so I'm using the autonumber field. So far, everything in the table/form is working. However, when I try to create a report from a query (to list all art numbers generated for each manual), the autonumber field shows "General Number". How do I fix this

Also, I wanted to give the autonumber a prefix of say "S000" so it doesn't start right at "1". How is this done? I've seen these 2 problems done on 2 other databases I did not work on, and can't figure out how to do it

I am a newbie at this, so any help will be appreciated :

Thanks in advance
Raissa
 
Raissa said:
I am creating a database to track art generated for manuals. Each piece
Click to expand...
of art should have a unique number (NO duplicates), so I'm using the
autonumber field. So far, everything in the table/form is working.
However, when I try to create a report from a query (to list all art
numbers generated for each manual), the autonumber field shows "General
Number". How do I fix this?

The format property for the control should be...
General Format
....not
"General Format"

Format Strings need to be in quotes. Named formats should not be.
Also, I wanted to give the autonumber a prefix of say "S000" so it
Click to expand...
doesn't start right at "1". How is this done? I've seen these 2 problems
done on 2 other databases I did not work on, and can't figure out how to do
it.

Instead of "General Format" (without the quotes), use a format property of
"S000" (this time WITH the quotes).
 
For the correct and incorrect uses of Autonumber fields, do a Find or a
Goggle search on the word on this newsgroup. I believe that there is also a
succinct discourse on http://mvps.org/access In those searches you'll also
find suggestions as to how to create and manage your own sequence numbers.

Use format() to control the display of a number

HTH
--
-Larry-
--

Raissa said:
I am creating a database to track art generated for manuals. Each piece
Click to expand...
of art should have a unique number (NO duplicates), so I'm using the
autonumber field. So far, everything in the table/form is working.
However, when I try to create a report from a query (to list all art numbers
generated for each manual), the autonumber field shows "General Number".
How do I fix this?
Also, I wanted to give the autonumber a prefix of say "S000" so it doesn't
Click to expand...
start right at "1". How is this done? I've seen these 2 problems done on 2
other databases I did not work on, and can't figure out how to do it.
 
Back
Top