(Hopefully!) a very easy question to answer - running a query from a command button

[potatohead]

Hi all

I'm currently working through developing my first database.

Basically, what I would like is for a query to run from a command button.

The query should look at a field in a table (a yes/no field) and report back the ones that have been filled in.

I know how to run the query from the access 'Query' window, BUT, I would like this query to run from a click of a command button on a form.

I've looked it up in a book, which explains about SQL, and didn't really understand it. I've also searched on here, but people talk about Macro's, and I don't know anything about them.

Can anyone help?

Cheers

 

[KenHigg]

This all depends on what yo mean by 'report back'. Do you simply need a message box to pop up with the count or do you need display the results in a form?

 

[potatohead]

It's alright - I've got it sorted!

Cheers!!