Access Generated Reports

[jenny23]

Access generated reports help

Hello friends,
Thank you for reading my message.
I am trying to generate a report in Access 2002 but I am stuck in this one. Please help me to figure out.

I have a data entry form, every time a user submit a form, then data is stored in a table.
This table stored questions and answers.
Each question has multiple answers.

I am trying to generate a report so that it has an AUTOMATIC report ID, for example, rpt300-001, rpt300-005, rpt301-002,....
001, 002, 005 are the number of answers for each question.
300, 301 are the question numbers.

I know how to make rpt300, rpt301.... and increment for the AUTOMATIC ID, but I don't know how to make rpt300-001, rpt300-002....

Please help.

Jenny.

 

[joeselch]

Place a Text Box on your report and set its Control Source to an expression that concatenates the two values (question and answer numbers) - something like:

QuestionNumber & "-" & AnswerNumber​