Query prompt one column for multiple random values
in [Queries]
|
From: rcs on 4 Mar 2010 22:02 I can write a query that prompts one field for a specific value, but would like user to enter multiple criteria Example - Lot numbers range from 1 to 140 transportation back to original consignor is provided by one individual, he is picking up lots 2, 50, 76 and 32 so I want to have these values on the load out ticket How do I allow for nonconsecutive values to be entered?
From: John Spencer on 5 Mar 2010 09:31 You could use a where clause that looked like the following. Replace LotNumber with the name of your field. WHERE Instr(1,"/" & [Enter lot numbers separated by slashes 1/2/53] & "/","/" & [LotNumber] & "/") > 0 In query design view that would probably look like: Field: Instr(1,"/" & [Enter lot numbers separated by slashes 1/2/53] & "/","/" & [LotNumber] & "/") Criteria: > 0 A better solution would involve VBA and building the query string (or at least the where portion of the query) after the user enters choices on a form. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County rcs wrote: > I can write a query that prompts one field for a specific value, but would > like user to enter multiple criteria > > Example - Lot numbers range from 1 to 140 > > transportation back to original consignor is provided by one individual, he > is picking up lots 2, 50, 76 and 32 so I want to have these values on the > load out ticket > > How do I allow for nonconsecutive values to be entered?
|
Pages: 1 Prev: Microsoft SQL Server Management Studio / Convert Date Next: calculated field - difficult |