Query-for specific records?

[sirnickettynox]

Hi all, Just put together an Club Members table containing female & male members which are identified using a gender column ie M or F. Now I would like to produce a query for females only and a query for males only from the Club Members table. After using the Query Wizard I was successful in separating the two genders but both end up on the same query. Can anyone help please.

Would it be better to just make up a seperate table for each gender instead??

[pbaldy]

You'd put a criteria on the gender field. Most of us would probably use one query, and have the criteria point to a form where you can choose which one you want, or both.

[sirnickettynox]

Thanks for you reply Paul, much appreciated. Being a newbe at access or any db stuff I'll have to have a good think about this and hopefully work it out. If it's not too much trouble is it possible for you to take me through your suggestion in point form? Looking at my newly created query in design, the criteria in the Gender Field has the following note:

'In (SELECT [Gender] FROM [MEMBERS] As Tmp GROUP BY [Gender] HAVING Count(*)>1 )'

Am I on the right track? If so what do I write in its place to make it work?

------------------------------
Marek.

[pbaldy]

That doesn't look like what I had in mind. For a straight query:

SELECT * FROM Members WHERE Gender = "F"

To look at a form for a user selected criteria:

SELECT * FROM Members WHERE Gender = Forms!FormName.ControlName

[sirnickettynox]

Thanks Paul, didn't quite get it but after reading up on query criteria and experimenting a little I found that putting in the criteria Like "f" or Like "m" does the trick! This is so cool!

[pbaldy]

Glad you got it working, and welcome to the site by the way!

[sirnickettynox]

Thanks for your help Paul, I now have a much better understanding of what setting a Criteria and Filtering is all about, to me this has been a quantum leap forward in better understanding how Access works, still have a long way to go but each time I learn something new makes me more interested in Access and DB in general, I now actually believe I will produce a fully workable DB very soon, only a couple of days ago I had doubts about that. So glad I found your Access Forums site, it's great!
regards,
Marek