[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Question about numeric and alpha caricatures when outputting?

Posted on 2016-10-06
8
Medium Priority
?
64 Views
Last Modified: 2016-12-01
Hi,

Is it possible to change the viewing, reporting and printing to see its Alpha setting instead? I created drop down menus from control boxes. The menus work well but when you view the data you see the numeric ID associated to it. Example, I created a drop down menu for US States. You select NJ as your choice. When you view or print, you see a 16 instead of NJ. I know the 16 is shown because it is NJ's numeric ID within the menu choices.

How do I change this to display Alpha instead of numeric?
Thanks
Earl
0
Comment
Question by:Earl Wolf
[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
8 Comments
 
LVL 66

Expert Comment

by:Jim Horn
ID: 41831806
Please give us a screen shot of what you're trying to pull off here, and specify if you are using Access Forms/Reports or SSRS.
0
 
LVL 31

Accepted Solution

by:
Helen Feddema earned 1000 total points
ID: 41831811
Column widthsIf the number is in the 1st column (it usually is), just make that column width 0 to hide it.
0
 
LVL 39

Assisted Solution

by:PatHartman
PatHartman earned 500 total points
ID: 41832138
When you want to include the lookup value in your output, you must include a join to the lookup table and select the alpha value from there.

Select MainTable.CustID, MainTable.CustName, StateTable.StateName From MainTable Left Join StateTable
ON MainTableStateID = StateTable.StateID;

You can include the ID field or not depending on how you are using the query.  You will need the ID field ONLY if you are using the query as the RecordSource for a form or VBA procedure where StateID may need to be updated.
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
LVL 66

Assisted Solution

by:Jim Horn
Jim Horn earned 500 total points
ID: 41832146
>How do I change this to display Alpha instead of numeric?
Make sure the zero in the Data Widths is for the numeric, and make sure the Bound Column number is for the Alpha.
And as Pat illustrated above, make sure the Record Source SQL contains both columns.
0
 
LVL 39

Expert Comment

by:PatHartman
ID: 41832166
Jim prompted me to reread the question.  If the problem is with the combobox itself, then Helen provided the answer.  You have to adjust the column widths.   If the problem is with a report or an export, then I provided the answer.
0
 

Author Comment

by:Earl Wolf
ID: 41832508
thanks to all, I will see which issue it is. Either the comboBox or report
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

656 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