2 column list box row source

  • Thread starter Thread starter NHMM
  • Start date Start date
N

NHMM

I am trying to populate a 2-column list box using distict values from a
query. I can get it to work with 1 column but not two. I keep getting a
missing operator error on the second column.

My row source currently looks like:
SELECT DISTINCT qry_quote.tag, qry_quote.tag description FROM qry_quote

The two columns are directly related, for example:
TAG TAG DESCRIPTION
C Compressor
F Filter
V Valve
etc, each tag has a unique description

What am I missing?
Thanks,
NHMM
 
The problem is the space in the field name.

Most of us advise not to include spaces. If you do, you must enclose the
name in square brackets:

SELECT DISTINCT qry_quote.tag, qry_quote.[tag description] FROM qry_quote
 
Back
Top