List Box field criteria query

  • Thread starter Thread starter Carolyn
  • Start date Start date
C

Carolyn

I need to do a query with criteria under a field that
contains a list box. When I attemt to set criteria for a
value among the list items, nothing comes up. How does
one query a list box field?

For example: my list box contains two "membership
types"..."full" and "associate." I want to query
only "full" members.

Thanks,

Carolyn
 
Is this list box using a Lookup from another table? If so, then what is the
real value in the table? If "membership" is really a code number (1 =
"full", 2 = "associate", etc.), then your criteria must be the number, not
the text.

See also: http://www.mvps.org/access/lookupfields.htm

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
Back
Top