Table drop-down values disappear in query

A

Access Non-Pro

A field created in a table using the Lookup Wizard displays the proper
drop-down values when viewed in the table. However, when that field is added
to a query, it loses the drop-down values and becomes a regular text field.
I've never seen this problem in years of using Access. What is happening
here? Thank you.
 
D

Duane Hookom

Many of us veteran Access developers would never use a lookup field. Why not
just add the table to your query that stores the actual value you want to
display?
 
A

Access Non-Pro

Sorry, I don't follow you. I've used this method many times over without a
problem until now. If I create a query with only the field with the
drop-down values included, the the field works as expected in query view.
When the other fields from the table are added, it ceases to function
normally. Thank you.
 
D

Duane Hookom

Sorry, I don't know why you don't just do as i suggested. Break free from
lookup fields and use the standard SQL functionality to display the value you
want to display. If you really don't want to follow my suggestions, you might
want to post your SQL view.
 
A

Access Non-Pro

I don't know SQL and I'm not sure how to post an SQL view. I'm a practical
user seeking the simplest path to accomplish an end. All I know is that
something that has always worked before is not working now. Thank you.
 
D

Duane Hookom

You mentioned "a query" in your first post. You should be able to change the
view to SQL and post the results to us. It might help if you replied with
additional information about your tables and fields.
 
A

Access Non-Pro

Duane,

It is a simple field with five response choices:
20a. If “PMAP†specify name:
___ Medica
___ Health Partners
___ UCare
___ MHP
___ Blue Plus
These five are listed in a drop-down combo box.

Here is the SQL:

SELECT [HSIS ID Number] & [Episode Open Date] AS [HSIS-Open Date], [Q13b -
If Q12 yes, indicate discharge date]-[Q13a - If Q12 yes, indicate admission
date] AS [LOS - AMRTC], [Episode Close Date]-[Episode Open Date] AS [LOS -
Episode], Format(([Episode Open Date]-[DOB])/365.35,"0.0") AS [Age at
Opening], [Main Client Data Table].Sequencer, [Main Client Data
Table].[Client Last Name], [Main Client Data Table].[Client First Name],
[Main Client Data Table].DOB, [Main Client Data Table].[Episode Open Date],
[Main Client Data Table].[HSIS ID Number], [Main Client Data Table].[ABH
Program Completing Form], [Main Client Data Table].[CART Worker Name], [Main
Client Data Table].REF, [Main Client Data Table].[Q1 - Number of psychiatric
hospitalizations in past 2 years], [Main Client Data Table].[Q2 - Number of
detox admissions in past 2 years], [Main Client Data Table].[Q3 - Number of
visits to APS in past 2 years], [Main Client Data Table].[Q4a - Number of
prior commitments in past 5 years to MI], [Main Client Data Table].[Q4b -
Number of prior commitments in past 5 years to CD], [Main Client Data
Table].[Q4c - Number of prior commitments in past 5 years to MI/CD], [Main
Client Data Table].[Q4d - DD (alone or with MI, and/or CD)], [Main Client
Data Table].[Q5 - Diagnosed MI], [Main Client Data Table].[Q5a - Primarily
thought disorder], [Main Client Data Table].[Q5b - Primarily mood disorder],
[Main Client Data Table].[Q5c - MI diagnosis NA], [Main Client Data
Table].[Q6 - Diagnosed MI/CD], [Main Client Data Table].[Q7 - Diagnosed
chemically dependent], [Main Client Data Table].[Q8 - Meets SPMI criteria],
[Main Client Data Table].[Q9 - Diagnosed Personality Disorder], [Main Client
Data Table].[Q10 - Severe psychiatric symptoms (and not 5-9 above)], [Main
Client Data Table].[Q11 - History of non-compliance w/psychotropic meds in],
[Main Client Data Table].[Q12 - History of suicide attempts/severe self-harm
in past year], [Main Client Data Table].[Q13 - Low intellectual functioning
(IQ<80)], [Main Client Data Table].[Q14 - Client is self-neglecting
vulnerable adult], [Main Client Data Table].[Q15 - Client has chronic/severe
medical condition/physical disab], [Main Client Data Table].[Q16 - Arrests
for threatening behavior past 2 years (SIP)], [Main Client Data Table].[Q17 -
History of misdemeanor or felony offenses in past 2 years], [Main Client Data
Table].[Q18 - Lacks/is at risk of losing sustaining income], [Main Client
Data Table].[Q19a - Income at intake - employment], [Main Client Data
Table].[Q19b - Income at intake - relatives/friends], [Main Client Data
Table].[Q19c - Income at intake - SSI], [Main Client Data Table].[Q19d -
Income at intake - RSDI], [Main Client Data Table].[Q19e - Income at intake -
GA], [Main Client Data Table].[Q19f - Income at intake - VA], [Main Client
Data Table].[Q19g - Income at intake - other], [Main Client Data Table].[Q19h
- Income at intake - none], [Main Client Data Table].[Q20a - Health coverage
at intake - MA], [Main Client Data Table].[Q20b - Health coverage at intake -
private], [Main Client Data Table].[Q20c - Health coverage at intake -
Medicare], [Main Client Data Table].[Q20d - Health coverage at intake -
GAMC], [Main Client Data Table].[Q20e - Health coverage at intake - MN Care],
[Main Client Data Table].[Q20f - Health coverage at intake - PMAP], [Main
Client Data Table].[Q20g - Health coverage at intake - VA], [Main Client Data
Table].[Q20h - Health coverage at intake - other], [Main Client Data
Table].[Q20i - Health coverage at intake - none], [Main Client Data
Table].[PSP Only - Case went to court?], [Main Client Data Table].[If PMAP
specify name], [Main Client Data Table].[Q21 - At risk of homelessness],
[Main Client Data Table].[Q22 - Homeless], [Main Client Data Table].[Q23 -
Gender], [Main Client Data Table].[Q24 - Race], [Main Client Data Table].[Q25
- Is client a foreign national?], [Main Client Data Table].[Q26 - Is client
Hispanic?], [Main Client Data Table].[Q1 - Primary Diagnosis], [Main Client
Data Table].[Q1a - Primary Diagnosis- Other (if indicated in Q1)], [Main
Client Data Table].[Q2 - Secondary Diagnosis], [Main Client Data Table].[Q2a
- Secondary Diagnosis- Other (if indicated in Q2)], [Main Client Data
Table].[Q3 - Substance Use], [Main Client Data Table].[Q4 - Commitment Status
at Opening], [Main Client Data Table].[Q5- Client admitted to RTC & continues
to receive CART services?], [Main Client Data Table].[Q5a - If Q5 yes, what
was admit date?], [Main Client Data Table].[Q6a - Housing status - Stable,
living situation permanent], [Main Client Data Table].[Q6b - Housing status -
At risk], [Main Client Data Table].[Q6c - Housing status - Lost], [Main
Client Data Table].[Q6d - Housing status - Transitional], [Main Client Data
Table].[Q6e - Housing status - Homeless], [Main Client Data Table].[Q7 -
Living situation at CART open], [Main Client Data Table].[Q8 - Client's
employment status at opening], [Main Client Data Table].[Q9 - Closed from
CART and now returning?], [Main Client Data Table].[Q10 - If Q9 yes, enter
reason], [Main Client Data Table].[Q11 - Referral Source], [Main Client Data
Table].[Q11a - If other, specify], [Main Client Data Table].[Episode Close
Date], [Main Client Data Table].[Q1 - CART Episode Number], [Main Client Data
Table].[Q2 - Provisional discharge revoked?], [Main Client Data Table].[Q3 -
Stay vacated and commitment executed?], [Main Client Data Table].[Q4 -
Commitment extended?], [Main Client Data Table].[Q5a - Housing status at
closing - Stable], [Main Client Data Table].[Q5b - Housing status at closing
- At risk], [Main Client Data Table].[Q5c - Housing status at closing -
Lost], [Main Client Data Table].[Q5d - Housing status at closing -
Transitional], [Main Client Data Table].[Q5e - Housing status at closing -
Homeless], [Main Client Data Table].[Q5f - Housing status at closing - RTC],
[Main Client Data Table].[Q6a - Closing status - No further services needed],
[Main Client Data Table].[Q6b - Closing status - Referred to TCM/long term
CM], [Main Client Data Table].[Q6c - Closing status - Referred to ACT], [Main
Client Data Table].[Q6d - Closing status - Referred to other services in
ABH], [Main Client Data Table].[Q6e - Closing status - Referred to other
non-ABH services], [Main Client Data Table].[Q6f - Closing status - Client
request - against team advice], [Main Client Data Table].[Q6g - Closing
status - Client request - no further services], [Main Client Data Table].[Q6h
- Closing status - Client missing], [Main Client Data Table].[Q6i - Closing
status - Client committed], [Main Client Data Table].[Q6j - Closing status -
Court involvement completed], [Main Client Data Table].[Q7 - Connectedness to
family at closing - contact for support], [Main Client Data Table].[Q8-
Medication compliance at closing- taking prescribed medicine], [Main Client
Data Table].[Q9 - Client had detox admissions while in CART], [Main Client
Data Table].[Q10 - if detox admissions while in CART, specify number], [Main
Client Data Table].[Q11a - Services provided in CART - Prepetition
screening], [Main Client Data Table].[Q11b - Services provided in CART -
Psychiatric evaluation], [Main Client Data Table].[Q11c - Services provided
in CART - Diagnostic assessment], [Main Client Data Table].[Q11d - Services
provided in CART - Rule 25 assessment], [Main Client Data Table].[Q11e -
Services provided in CART - Outpatient therapy], [Main Client Data
Table].[Q11f - Services provided in CART - Nancy Page], [Main Client Data
Table].[Q11g - Services provided in CART - Partial hospitalization], [Main
Client Data Table].[Q11h - Services provided in CART - Day treatment], [Main
Client Data Table].[Q11i - Services provided in CART - Medication education],
[Main Client Data Table].[Q11j - Services provided in CART - Medication
monitoring], [Main Client Data Table].[Q11k - Services provided in CART -
Family education], [Main Client Data Table].[Q11l - Services provided in CART
- Assistance in entitlements], [Main Client Data Table].[Q11m- Services
provided in CART - Assistance in health insurance], [Main Client Data
Table].[Q11n - Services provided in CART - ARMHS], [Main Client Data
Table].[Q11o - Services provided in CART - None], [Main Client Data
Table].[Q12 - Client admitted to AMRTC while in CART?], [Main Client Data
Table].[Q13a - If Q12 yes, indicate admission date], [Main Client Data
Table].[Q13b - If Q12 yes, indicate discharge date], [Main Client Data
Table].[Q15 - Client reopened in CART during past 6 months], [Main Client
Data Table].[Q16 - Client is in TCM/long-term CM at 6-month followup], [Main
Client Data Table].[Q17 - Client is in an ACT program at 6-month followup],
[Main Client Data Table].[Q18 - Client was screened by PSP during past 6
months], [Main Client Data Table].[Q19 - Client had detox admissions during
last 6 months], [Main Client Data Table].[Q19a - If yes, specify number:],
[Main Client Data Table].[Q20 - Client served by COPE during past 6 months],
[Main Client Data Table].[Q20a - If yes, specify number of times], [Main
Client Data Table].[Q21 - Client was admitted to AMRTC during last 6 months],
[Main Client Data Table].[Q1 - Consumer's living situation at case closing],
[Main Client Data Table].[Q2 - Client's living situation is appropriate?],
[Main Client Data Table].[Q3 - If not really, or not at all, why not?], [Main
Client Data Table].[Q4 - Consumer has enough money to meet basic needs],
[Main Client Data Table].[Q5a - Client income - Employment], [Main Client
Data Table].[Q5b - Client income - Support of relatives/friends], [Main
Client Data Table].[Q5c - Client income - SSI], [Main Client Data Table].[Q5d
- Client income - RSDI], [Main Client Data Table].[Q5e - Client income - GA],
[Main Client Data Table].[Q5f - Client income - VA], [Main Client Data
Table].[Q5g - Client income - Unemployment compensation], [Main Client Data
Table].[Q5h - Client income - Other income], [Main Client Data Table].[Q5i -
If other, specify type], [Main Client Data Table].[Q6 - Client can identify
persons to contact for support], [Main Client Data Table].[Q7a - Client
participates in Community Support Program], [Main Client Data Table].[Q7b -
Client participates in Day Treatment], [Main Client Data Table].[Q7c - Client
participates in outpatient treatment], [Main Client Data Table].[Q7d - Client
participates in employment], [Main Client Data Table].[Q7e - Client
participates in spiritual practices], [Main Client Data Table].[Q7f - Client
participates in education], [Main Client Data Table].[Q7g - Client
participates in other things], [Main Client Data Table].[Q7h - Client
participates in none of the above], [Main Client Data Table].[Q8 - Client's
employment status at closing], [Main Client Data Table].[Q9a - Health
coverage at closing - MA], [Main Client Data Table].[Q9b - Health coverage at
closing - Private], [Main Client Data Table].[Q9c - Health coverage at
closing - Medicare], [Main Client Data Table].[Q9d - Health coverage at
closing - GAMC], [Main Client Data Table].[Q9e - Health coverage at closing -
MN Care], [Main Client Data Table].[Q9f - Health coverage at closing - PMAP],
[Main Client Data Table].[Q9g - Health coverage at closing - VA], [Main
Client Data Table].[Q9h - Health coverage at closing - Other], [Main Client
Data Table].[Q9i - Health coverage at closing - None]
FROM [Main Client Data Table];

Thanks - I hope you can spot something.

Access Non-Pro

____________________________________________________________________
 
D

Duane Hookom

Don't you have a small lookup table with the code and title of the PMAPs?
This could be joined to your main table to display the titles.

I'm trying to hold back on being critical of your table structure. There are
so many "values" that are used as fields names. For example, I would remove
the "income" fields and create a related table with these fields:
tblPatientIncome
==============
[HSIS ID Number] (or whatever is the primary key from [Main Client Data
Table])
IncomeType (values for employment, SSI, relatives/friends,... Other)
IncomeAmt

This would not limit you to 8 choices and would allow you to easily sum the
income across records rather than across fields. This is referred to as
"normalization".

In addition, your Age field isn't entirely accurate and should not be
formatted in the query. Save the formatting to your report or form controls.

Maybe this structure works for you but it lacks flexibility and functionality.
--
Duane Hookom
Microsoft Access MVP


Access Non-Pro said:
Duane,

It is a simple field with five response choices:
20a. If “PMAP†specify name:
___ Medica
___ Health Partners
___ UCare
___ MHP
___ Blue Plus
These five are listed in a drop-down combo box.

Here is the SQL:

SELECT [HSIS ID Number] & [Episode Open Date] AS [HSIS-Open Date], [Q13b -
If Q12 yes, indicate discharge date]-[Q13a - If Q12 yes, indicate admission
date] AS [LOS - AMRTC], [Episode Close Date]-[Episode Open Date] AS [LOS -
Episode], Format(([Episode Open Date]-[DOB])/365.35,"0.0") AS [Age at
Opening], [Main Client Data Table].Sequencer, [Main Client Data
Table].[Client Last Name], [Main Client Data Table].[Client First Name],
[Main Client Data Table].DOB, [Main Client Data Table].[Episode Open Date],
[Main Client Data Table].[HSIS ID Number], [Main Client Data Table].[ABH
Program Completing Form], [Main Client Data Table].[CART Worker Name], [Main
Client Data Table].REF, [Main Client Data Table].[Q1 - Number of psychiatric
hospitalizations in past 2 years], [Main Client Data Table].[Q2 - Number of
detox admissions in past 2 years], [Main Client Data Table].[Q3 - Number of
visits to APS in past 2 years], [Main Client Data Table].[Q4a - Number of
prior commitments in past 5 years to MI], [Main Client Data Table].[Q4b -
Number of prior commitments in past 5 years to CD], [Main Client Data
Table].[Q4c - Number of prior commitments in past 5 years to MI/CD], [Main
Client Data Table].[Q4d - DD (alone or with MI, and/or CD)], [Main Client
Data Table].[Q5 - Diagnosed MI], [Main Client Data Table].[Q5a - Primarily
thought disorder], [Main Client Data Table].[Q5b - Primarily mood disorder],
[Main Client Data Table].[Q5c - MI diagnosis NA], [Main Client Data
Table].[Q6 - Diagnosed MI/CD], [Main Client Data Table].[Q7 - Diagnosed
chemically dependent], [Main Client Data Table].[Q8 - Meets SPMI criteria],
[Main Client Data Table].[Q9 - Diagnosed Personality Disorder], [Main Client
Data Table].[Q10 - Severe psychiatric symptoms (and not 5-9 above)], [Main
Client Data Table].[Q11 - History of non-compliance w/psychotropic meds in],
[Main Client Data Table].[Q12 - History of suicide attempts/severe self-harm
in past year], [Main Client Data Table].[Q13 - Low intellectual functioning
(IQ<80)], [Main Client Data Table].[Q14 - Client is self-neglecting
vulnerable adult], [Main Client Data Table].[Q15 - Client has chronic/severe
medical condition/physical disab], [Main Client Data Table].[Q16 - Arrests
for threatening behavior past 2 years (SIP)], [Main Client Data Table].[Q17 -
History of misdemeanor or felony offenses in past 2 years], [Main Client Data
Table].[Q18 - Lacks/is at risk of losing sustaining income], [Main Client
Data Table].[Q19a - Income at intake - employment], [Main Client Data
Table].[Q19b - Income at intake - relatives/friends], [Main Client Data
Table].[Q19c - Income at intake - SSI], [Main Client Data Table].[Q19d -
Income at intake - RSDI], [Main Client Data Table].[Q19e - Income at intake -
GA], [Main Client Data Table].[Q19f - Income at intake - VA], [Main Client
Data Table].[Q19g - Income at intake - other], [Main Client Data Table].[Q19h
- Income at intake - none], [Main Client Data Table].[Q20a - Health coverage
at intake - MA], [Main Client Data Table].[Q20b - Health coverage at intake -
private], [Main Client Data Table].[Q20c - Health coverage at intake -
Medicare], [Main Client Data Table].[Q20d - Health coverage at intake -
GAMC], [Main Client Data Table].[Q20e - Health coverage at intake - MN Care],
[Main Client Data Table].[Q20f - Health coverage at intake - PMAP], [Main
Client Data Table].[Q20g - Health coverage at intake - VA], [Main Client Data
Table].[Q20h - Health coverage at intake - other], [Main Client Data
Table].[Q20i - Health coverage at intake - none], [Main Client Data
Table].[PSP Only - Case went to court?], [Main Client Data Table].[If PMAP
specify name], [Main Client Data Table].[Q21 - At risk of homelessness],
[Main Client Data Table].[Q22 - Homeless], [Main Client Data Table].[Q23 -
Gender], [Main Client Data Table].[Q24 - Race], [Main Client Data Table].[Q25
- Is client a foreign national?], [Main Client Data Table].[Q26 - Is client
Hispanic?], [Main Client Data Table].[Q1 - Primary Diagnosis], [Main Client
Data Table].[Q1a - Primary Diagnosis- Other (if indicated in Q1)], [Main
Client Data Table].[Q2 - Secondary Diagnosis], [Main Client Data Table].[Q2a
- Secondary Diagnosis- Other (if indicated in Q2)], [Main Client Data
Table].[Q3 - Substance Use], [Main Client Data Table].[Q4 - Commitment Status
at Opening], [Main Client Data Table].[Q5- Client admitted to RTC & continues
to receive CART services?], [Main Client Data Table].[Q5a - If Q5 yes, what
was admit date?], [Main Client Data Table].[Q6a - Housing status - Stable,
living situation permanent], [Main Client Data Table].[Q6b - Housing status -
At risk], [Main Client Data Table].[Q6c - Housing status - Lost], [Main
Client Data Table].[Q6d - Housing status - Transitional], [Main Client Data
Table].[Q6e - Housing status - Homeless], [Main Client Data Table].[Q7 -
Living situation at CART open], [Main Client Data Table].[Q8 - Client's
employment status at opening], [Main Client Data Table].[Q9 - Closed from
CART and now returning?], [Main Client Data Table].[Q10 - If Q9 yes, enter
reason], [Main Client Data Table].[Q11 - Referral Source], [Main Client Data
Table].[Q11a - If other, specify], [Main Client Data Table].[Episode Close
Date], [Main Client Data Table].[Q1 - CART Episode Number], [Main Client Data
Table].[Q2 - Provisional discharge revoked?], [Main Client Data Table].[Q3 -
Stay vacated and commitment executed?], [Main Client Data Table].[Q4 -
Commitment extended?], [Main Client Data Table].[Q5a - Housing status at
closing - Stable], [Main Client Data Table].[Q5b - Housing status at closing
- At risk], [Main Client Data Table].[Q5c - Housing status at closing -
Lost], [Main Client Data Table].[Q5d - Housing status at closing -
Transitional], [Main Client Data Table].[Q5e - Housing status at closing -
Homeless], [Main Client Data Table].[Q5f - Housing status at closing - RTC],
[Main Client Data Table].[Q6a - Closing status - No further services needed],
[Main Client Data Table].[Q6b - Closing status - Referred to TCM/long term
CM], [Main Client Data Table].[Q6c - Closing status - Referred to ACT], [Main
Client Data Table].[Q6d - Closing status - Referred to other services in
ABH], [Main Client Data Table].[Q6e - Closing status - Referred to other
non-ABH services], [Main Client Data Table].[Q6f - Closing status - Client
request - against team advice], [Main Client Data Table].[Q6g - Closing
status - Client request - no further services], [Main Client Data Table].[Q6h
- Closing status - Client missing], [Main Client Data Table].[Q6i - Closing
status - Client committed], [Main Client Data Table].[Q6j - Closing status -
Court involvement completed], [Main Client Data Table].[Q7 - Connectedness to
family at closing - contact for support], [Main Client Data Table].[Q8-
Medication compliance at closing- taking prescribed medicine], [Main Client
Data Table].[Q9 - Client had detox admissions while in CART], [Main Client
Data Table].[Q10 - if detox admissions while in CART, specify number], [Main
Client Data Table].[Q11a - Services provided in CART - Prepetition
screening], [Main Client Data Table].[Q11b - Services provided in CART -
Psychiatric evaluation], [Main Client Data Table].[Q11c - Services provided
in CART - Diagnostic assessment], [Main Client Data Table].[Q11d - Services
provided in CART - Rule 25 assessment], [Main Client Data Table].[Q11e -
Services provided in CART - Outpatient therapy], [Main Client Data
Table].[Q11f - Services provided in CART - Nancy Page], [Main Client Data
Table].[Q11g - Services provided in CART - Partial hospitalization], [Main
Client Data Table].[Q11h - Services provided in CART - Day treatment], [Main
Client Data Table].[Q11i - Services provided in CART - Medication education],
[Main Client Data Table].[Q11j - Services provided in CART - Medication
monitoring], [Main Client Data Table].[Q11k - Services provided in CART -
Family education], [Main Client Data Table].[Q11l - Services provided in CART
- Assistance in entitlements], [Main Client Data Table].[Q11m- Services
provided in CART - Assistance in health insurance], [Main Client Data
Table].[Q11n - Services provided in CART - ARMHS], [Main Client Data
Table].[Q11o - Services provided in CART - None], [Main Client Data
Table].[Q12 - Client admitted to AMRTC while in CART?], [Main Client Data
Table].[Q13a - If Q12 yes, indicate admission date], [Main Client Data
Table].[Q13b - If Q12 yes, indicate discharge date], [Main Client Data
Table].[Q15 - Client reopened in CART during past 6 months], [Main Client
Data Table].[Q16 - Client is in TCM/long-term CM at 6-month followup], [Main
Client Data Table].[Q17 - Client is in an ACT program at 6-month followup],
[Main Client Data Table].[Q18 - Client was screened by PSP during past 6
months], [Main Client Data Table].[Q19 - Client had detox admissions during
last 6 months], [Main Client Data Table].[Q19a - If yes, specify number:],
[Main Client Data Table].[Q20 - Client served by COPE during past 6 months],
[Main Client Data Table].[Q20a - If yes, specify number of times], [Main
Client Data Table].[Q21 - Client was admitted to AMRTC during last 6 months],
[Main Client Data Table].[Q1 - Consumer's living situation at case closing],
[Main Client Data Table].[Q2 - Client's living situation is appropriate?],
[Main Client Data Table].[Q3 - If not really, or not at all, why not?], [Main
Client Data Table].[Q4 - Consumer has enough money to meet basic needs],
[Main Client Data Table].[Q5a - Client income - Employment], [Main Client
Data Table].[Q5b - Client income - Support of relatives/friends], [Main
Client Data Table].[Q5c - Client income - SSI], [Main Client Data Table].[Q5d
- Client income - RSDI], [Main Client Data Table].[Q5e - Client income - GA],
[Main Client Data Table].[Q5f - Client income - VA], [Main Client Data
Table].[Q5g - Client income - Unemployment compensation], [Main Client Data
Table].[Q5h - Client income - Other income], [Main Client Data Table].[Q5i -
If other, specify type], [Main Client Data Table].[Q6 - Client can identify
persons to contact for support], [Main Client Data Table].[Q7a - Client
participates in Community Support Program], [Main Client Data Table].[Q7b -
Client participates in Day Treatment], [Main Client Data Table].[Q7c - Client
participates in outpatient treatment], [Main Client Data Table].[Q7d - Client
participates in employment], [Main Client Data Table].[Q7e - Client
participates in spiritual practices], [Main Client Data Table].[Q7f - Client
participates in education], [Main Client Data Table].[Q7g - Client
participates in other things], [Main Client Data Table].[Q7h - Client
participates in none of the above], [Main Client Data Table].[Q8 - Client's
employment status at closing], [Main Client Data Table].[Q9a - Health
coverage at closing - MA], [Main Client Data Table].[Q9b - Health coverage at
closing - Private], [Main Client Data Table].[Q9c - Health coverage at
closing - Medicare], [Main Client Data Table].[Q9d - Health coverage at
closing - GAMC], [Main Client Data Table].[Q9e - Health coverage at closing -
MN Care], [Main Client Data Table].[Q9f - Health coverage at closing - PMAP],
[Main Client Data Table].[Q9g - Health coverage at closing - VA], [Main
Client Data Table].[Q9h - Health coverage at closing - Other], [Main Client
Data Table].[Q9i - Health coverage at closing - None]
FROM [Main Client Data Table];

Thanks - I hope you can spot something.

Access Non-Pro

____________________________________________________________________

Duane Hookom said:
You mentioned "a query" in your first post. You should be able to change the
view to SQL and post the results to us. It might help if you replied with
additional information about your tables and fields.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hide drop down in query result 2
Quering a drop down column from a table 2
Update Query Question 2
Using a fields drop down selection to populate 2nd fields drop dow 1
Creating a select query from multiple fields on the same table 2
drop down menu in query 1
dynamic calculated field in query 3
Query Criteria 2

Top