Hello All!

This may be a fairly stupid question.
How do you create a query that is based on user input?

Thanks,

JW624

Presumably you mean to get criteria from the user. Most of us have the user enter the value in a form, and the criteria would be:

Forms!FormName.ControlName

You can also have something like this:

[Enter value]

in the criteria and the query will prompt the user.

Say I was setting it up to run from a button on a form, which way would be the best to go about it?

Personally I always use forms for user input. You have a lot more control than using the brackets. I'd have controls on the form that they fill out before running the query.