ms access - Helpdesk ticket system

I would like to create a ticket description field on MS Access, which grab a data from other fields and create a ticket description Automatically.
1. field - PC or Wyse
2. field - Location
3. field - trouble type
4. field - extension
5. field - urgency
Hiroyuki TamuraField EngineerAsked:
Who is Participating?
PatHartmanConnect With a Mentor Commented:
You can use vbCR or maybe vbCRLF but I wouldn't do this in a query.  I would do it in the report.  In fact, if you lay out the report correctly, you shouldn't even be concatenating the additional lines.  Access is able to suppress printing an entire line if it contains no data so for the typical address label with four lines - name; addr1; addr2; city & state & zip, the third line is usually suppressed.
If you want someone to attempt to write code for you, you'll need to provide more details.  What have you tried yourself?
Hiroyuki TamuraConnect With a Mentor Field EngineerAuthor Commented:
sorry, i would like to create calculation field.
On filemaker, they can use calculation field to create a text string like
[Field Name A] & " " &[Field Name B]
do you know how to create those field on MS Access?
PatHartmanConnect With a Mentor Commented:
The easiest place to do this is in a query.

Select fld1, fld2, fld3, [Field Name A] & " " & [Field Name B] As fldAB
From yourtable;
Hiroyuki TamuraConnect With a Mentor Field EngineerAuthor Commented:
Thank you, Pathartman,

if i want to set new line between [Field Name B] and [Field Name C]
what symbol could I use?

[Field Name A] &" "&  [Field Name B]
[Field Name C]
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.