Listbox query criteria

  • Thread starter Thread starter Monte Grant
  • Start date Start date
M

Monte Grant

In a listbox, I'd like a Column A record to show "Yes" if both

Column B record = yes

and

Column C record = 2


Otherwise the listbox column should show "No." How do I write this
statement?
 
Is the Row Source for the listbox a query? If so, try to do this in the
query by creating a calculated field.

CandB:IIf(=True And [C]=2, "Yes", "No")

You would then have a 3 column listbox with the calculated field as the
first column. The fields will fill the columns from left to right, so
arrange them in the query in the order you want them displayed.
 
Back
Top