Running a query on a table with a "/" as part of a field name

[JC10001]

Hi guys,

Hate to ask a question twice in the same day but...

I'd like to know if its possible to run a query on a table with a "/" as part of a field name. I'd like to place the query in the properties/rowsource portion of a combo box. I've tried brackets and a bunch of other stuff but I haven't had any luck. The field name is set in stone.

Thanks.

 

[pdx_man]

What problem are you currently having?

Let's see if I got this right ...
You have a table that has a '/' in one of the field names ...
You have a query that has this field in it
You want to use this query to populate a combobox

Whether your Row Source Type is a Field List or Table/Query, you should still get a popluation.

 

[JC10001]

What problem are you currently having?

Let's see if I got this right ...
You have a table that has a '/' in one of the field names ...
You have a query that has this field in it
You want to use this query to populate a combobox

Whether your Row Source Type is a Field List or Table/Query, you should still get a popluation.

You have it right. The thing is, its not working. For simplicity's sake lets assume the field name is "Yes/No". In the properties->rowsource part of my combo box I have the following query entered:

Select field_name from table_name where table_name.yes/no = value;

The above query does not generate any results whatsoever. I have also tried using [table_name.yes/no] and table_name.[yes/no] in the query but I still have not gotten any results.