Autonumber + Report

[Raissa]

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

 

[Rick Brandt]

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?

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

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