O'Connor, Patricia (OTDA)
Patricia.O'Connor at otda.state.ny.us
Mon Dec 5 13:14:57 CST 2005
In an Access 97 database
I have a case type field in a reference table that may contain 1 to 11
values depending on what cases are used in a particular report
examples report 1221 has this type 11
report 1321 has these types 11,12,14,16,17
The field is placed into a hidden text field on a form called
[Forms]![FrmBicMoSel]![txtSelCriteria]
The called query currently uses this field in the where statement this
way
(InStr([Forms]![FrmBicMoSel]![txtSelCriteria],[tlkpXrefDescID].[CaseType
])>0))
I would like to be able to use it with an IN statement
[tlkpXrefDescID].[CaseType] in([Forms]![FrmBicMoSel]![txtSelCriteria])
But it does not like this - how can I get this to work - I think there
is a function but I can't seem to remember it right now.
Thanks
******************************************************************
*Patricia O'Connor
*Associate Computer Programmer Analyst
*OTDA - BDMA
*(W) mailto:Patricia.O'Connor at otda.state.ny.us
*(w) mailto:aa1160 at otda.state.ny.us
******************************************************************
--------------------------------------------------------
This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.