If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
query values vs. query results
Don't know if this is a query querie or or report querie but here goes: I
created a summary query from a table that has 4 fields. The data source on three of these fields is table/query. Meaning the value that is actually stored in the original table is "1" but what displays in the query is "Kids". The summary query is correct, but what i need to do is share the query with others. When I create a report [or export] based on this query, all that shows up is the table values. How can I create a query that has the actual values in the query? Thank you! |
#2
|
|||
|
|||
query values vs. query results
Abbey,
Don't know if this is a query querie or or report querie A query is a query is a query... :-D There's no difference between a standalone query, or a query used as the RecordSource for a report. That said... Create a calculated (ex. name ClientType) bound field in the query using the Query Design grid. We'll assume the primary table has a field called MemberTypeNo that contains values from 1 to 3. ClientType : IIF(MemberTypeNo = 1, "Kids", IIF(MemberTypeNo = 2, "Adults", "Seniors")) OR... If you have many numbers to relate to string values, you could have a table like this... TypeNo MemberType 1 "Kids" 2 "Adults" 3 "Seniors" If this "translation" table were included in your query, and related to your primary table by MemberTypeNo to TypeNo, you could simply include the MemberType column in your query... and it will always display the correct corresponding text value (MemberType) for any MemberTypeNo. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Abbey Normal" wrote in message ... Don't know if this is a query querie or or report querie but here goes: I created a summary query from a table that has 4 fields. The data source on three of these fields is table/query. Meaning the value that is actually stored in the original table is "1" but what displays in the query is "Kids". The summary query is correct, but what i need to do is share the query with others. When I create a report [or export] based on this query, all that shows up is the table values. How can I create a query that has the actual values in the query? Thank you! |
#3
|
|||
|
|||
query values vs. query results
This is one of the problems with using Lookup fields. You'll find more
he http://www.mvps.org/access/lookupfields.htm Regardless, you'll have to join your main table to all the other tables represented in the lookup fields and display the display values rather than the linking values. -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "Abbey Normal" wrote in message ... Don't know if this is a query querie or or report querie but here goes: I created a summary query from a table that has 4 fields. The data source on three of these fields is table/query. Meaning the value that is actually stored in the original table is "1" but what displays in the query is "Kids". The summary query is correct, but what i need to do is share the query with others. When I create a report [or export] based on this query, all that shows up is the table values. How can I create a query that has the actual values in the query? Thank you! |
#4
|
|||
|
|||
query values vs. query results
Ah hah! I always suspected these fields were evil, now I have proof!
Thank you for both your responses, they were both helpful. I now have a query that is joined to the other tables, and the actual values in the query. THanks again.... "Roger Carlson" wrote: This is one of the problems with using Lookup fields. You'll find more he http://www.mvps.org/access/lookupfields.htm Regardless, you'll have to join your main table to all the other tables represented in the lookup fields and display the display values rather than the linking values. -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "Abbey Normal" wrote in message ... Don't know if this is a query querie or or report querie but here goes: I created a summary query from a table that has 4 fields. The data source on three of these fields is table/query. Meaning the value that is actually stored in the original table is "1" but what displays in the query is "Kids". The summary query is correct, but what i need to do is share the query with others. When I create a report [or export] based on this query, all that shows up is the table values. How can I create a query that has the actual values in the query? Thank you! |
Thread Tools | |
Display Modes | |
|
|