report using only one value on a combo box

[mustbemad]

Hi,

I'm still learning here and at the rank beginner stage so please be gentle.

After getting a bit of advice I made our database using a template and altering what needed, adding in drop down boxes all good.

Everyone is happy

Now I need to be able to print a report using only one of the options from a drop down box. ie

last name
first name
dogs name
assorted guff phone etc.
status << this is a drop down box with either active or inactive as the only options.

I need to print only active members and their details.

Is there an easy way to do this? given I know nothing about access, I've seen a couple of tutorials but they are way over my head and use code that makes me want to hide.


I am learning and have my test database that isn't based on a template but by the time I'm equipped to make my own membership database I'll be retired.

any help appreciated.

Jen

 

[pbaldy]

Create a query and put "active" in the criteria of the status field, and base the report on that query.

 

[mustbemad]

thank you!!

 

[pbaldy]

Happy to help!