Help with simple WHERE query

[accessmatt]

Hello,

I'm trying to use this query in Access to pull entries called Enterprise from Brand/Indication in Table1 but when I press run it just prompts me for a parameter. How can I re-write the query to just pull the table for me: no inputs.

SELECT Table1.[Brand/Indication]FROM Table1
WHERE ((([Brand]/[Indication])='Enterprise'));

Thanks,

Matt

[ItsMe]

What is the name of the field?
Brand/Indication

Try
WHERE ((([Brand/Indication])='Enterprise'))

Also, recommend not using special characters, spaces, and reserved words in names.