Jürgen Welz
jwelz at hotmail.com
Tue Dec 6 15:04:32 CST 2005
Gustav: It took me a bit of poking using various search terms to come up with a November archive and I see you already provided the answer I suggest there. The archive seems to be set up in month segments but using the seach to find a particular month in the past seemed somewhat hit and miss. I guess I'll have to browse around a bit more. Ciao Jürgen Welz Edmonton, Alberta jwelz at hotmail.com >>From: "Gustav Brock" <Gustav at cactus.dk> >> >>Hi Patricia >> >>Though it would be nice, you can't do this. Look up my post dated: >> 2005-11-21 09:55 >> >>subject: >> SQL - IN Operator - Possible to use parameter >> >>/gustav >> >> >>> Patricia.O'Connor at otda.state.ny.us 05-12-2005 20:14 >>> >>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. > > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com