Solved

Question about numeric and alpha caricatures when outputting?

Posted on 2016-10-06
8
44 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
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 250 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 35

Assisted Solution

by:PatHartman
PatHartman earned 125 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 65

Assisted Solution

by:Jim Horn
Jim Horn earned 125 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 35

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

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…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

792 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