query values vs. query results

[Guest]

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!

 

[Al Campagna]

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."

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!

 

[Roger Carlson]

This is one of the problems with using Lookup fields. You'll find more
here: 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/wa.exe?SUBED1=ACCESS-L

 

[Guest]

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....

This is one of the problems with using Lookup fields. You'll find more
here: 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/wa.exe?SUBED1=ACCESS-L

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!