Solved

Question about numeric and alpha caricatures when outputting?

Posted on 2016-10-06
8
31 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
8 Comments
 
LVL 65

Expert Comment

by:Jim Horn
Comment Utility
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 250 total points
Comment Utility
Column widthsIf the number is in the 1st column (it usually is), just make that column width 0 to hide it.
0
 
LVL 34

Assisted Solution

by:PatHartman
PatHartman earned 125 total points
Comment Utility
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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 65

Assisted Solution

by:Jim Horn
Jim Horn earned 125 total points
Comment Utility
>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 34

Expert Comment

by:PatHartman
Comment Utility
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
Comment Utility
thanks to all, I will see which issue it is. Either the comboBox or report
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

744 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now