?
Solved

ms access - Helpdesk ticket system

Posted on 2017-05-03
5
Medium Priority
?
161 Views
Last Modified: 2017-05-19
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
0
Comment
Question by:Hiroyuki Tamura
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 38

Expert Comment

by:PatHartman
ID: 42119740
If you want someone to attempt to write code for you, you'll need to provide more details.  What have you tried yourself?
0
 

Assisted Solution

by:Hiroyuki Tamura
Hiroyuki Tamura earned 0 total points
ID: 42120606
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?
0
 
LVL 38

Assisted Solution

by:PatHartman
PatHartman earned 2000 total points
ID: 42121651
The easiest place to do this is in a query.

Select fld1, fld2, fld3, [Field Name A] & " " & [Field Name B] As fldAB
From yourtable;
0
 

Assisted Solution

by:Hiroyuki Tamura
Hiroyuki Tamura earned 0 total points
ID: 42122108
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]
0
 
LVL 38

Accepted Solution

by:
PatHartman earned 2000 total points
ID: 42122252
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.
0

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question