Autonumber Field

[jenny23]

MS ACCESS: AUTOMATIC NUMBER field help please!

MS ACCESS: AUTOMATIC NUMBER field help please!
HELLO FRIENDS,
I created an AUTOMATIC FIELD and the format I want it generate automatically is like:
TRAN MALE 01
TRAN FEMALE 02
TRAN LESBIAN 03
TRAN GAY 04
TRAN MALE 05
TRAN MALE 06

IS THERE ANY WAY TO DO THIS WAY?

THANKS.

 

[Dreamboat]

So if the *gender* of the first record is TRAN GAY, you want the first record to be 04001, and if the second record is TRAN MALE, you want its record number to be 05002?

I mean...otherwise, how do we know the gender?
If you want the record number to READ as you show, then just concatenate on a form or query or report.

Suppose your autonumber field is called "mynum".
Suppose your gender field is called "mygen".

On your query, form, or report, just put:
=[mygen]&" "&[mynum]

 

[Uncle Gizmo]

>>>> How do we know the gender? <<<<<<

I can usually tell!


Crocodile Dundee can too!

 

[Dreamboat]

You know....I asked that question....thought about it and said...nahhh!!!
I was wrong. LOL!!

 

[jenny23]

Automatic Number

Actually, that is not my question.
My question is:
I am creating a form for question and answer tracking system. One question may have multiple answers. How do I generate an AUTOMATIC field that include the question and answers together?
For Ex: Q300-001, Q300-002, Q400-001, Q400-002, ETC...

THANKS.

 

[Dreamboat]

Create a query, add a field with this expression:

=[question]&"-"&[answer]

where "question" and "answer" are the field names of your question and your answer fields.

 

[jenny23]

Well, that gave me a hint but I am too newbie in access.
I am creating a form with 1st field called TRACKING #, with AUTOMACTIC VALUE.
Where do I add yours from my db? I mean, from Table or Form, and Where on Form or Table?
I tried to add right at the Format for Table, and Default for Form, but it won't work.
Also, I stored the question and answers in different tables.

big thanks.

 

[Dreamboat]

So you just need to see this value on the form?

Try this in a text box on your form:
=[tablename1!questionfieldname]&"-"&[tablename2!answerfieldname]