Need query to sort by CurrentYear members

[Jan Il]

Hi all - Access 2002 XP - WinXP Pro

I need a query to call up just current year members from a membership list
table that lists current and past members. The CurrentYear field has 2005
listed only for those members who have renewed their membership for 2005. I
also have a filter form with a command button to call up a form to display
only current members.

I am not sure what type of query I need to sort out just current members
based upon the CurrentYear field on the table. I also want to display all
the related information in the table for each current member as well, not
just their name.

I'd truly appreciate some suggestions on the best approach for this type of
query.

Jan
Smiles are meant to be shared,
that's why they're so contagious.

 

[Marshall Barton]

Hi all - Access 2002 XP - WinXP Pro

I need a query to call up just current year members from a membership list
table that lists current and past members. The CurrentYear field has 2005
listed only for those members who have renewed their membership for 2005. I
also have a filter form with a command button to call up a form to display
only current members.

I am not sure what type of query I need to sort out just current members
based upon the CurrentYear field on the table. I also want to display all
the related information in the table for each current member as well, not
just their name.

I'd truly appreciate some suggestions on the best approach for this type of
query.

Create a basic query, selecting the members table. In the
query design grid drag each of the desired fields from the
table field list down to an empty cell in the query's field
row.

To select for a specific value in one of the fields, just
enter the value you want to select for (in this case 2005)
in the criteria row under the field your want to check
(CurrentYear). There are many more sophisticated
expressions you can use in a criteria (e.g. <=2004) so play
around with it to get a feel for what you can do.

 

[Jan Il]

Hi Marshall

Create a basic query, selecting the members table. In the
query design grid drag each of the desired fields from the
table field list down to an empty cell in the query's field
row.

To select for a specific value in one of the fields, just
enter the value you want to select for (in this case 2005)
in the criteria row under the field your want to check
(CurrentYear). There are many more sophisticated
expressions you can use in a criteria (e.g. <=2004) so play
around with it to get a feel for what you can do.

Thank you very much for the information. I'll give it a go and see what I
can do with it. I thought of several ways, but, not sure which would work
best, and no need to get more complex than necessary. I really appreciate
your help.

Jan
Smiles are meant to be shared,
that's why they're so contagious.

 

[Jan Il]

Hi Marshall

Create a basic query, selecting the members table. In the
query design grid drag each of the desired fields from the
table field list down to an empty cell in the query's field
row.

To select for a specific value in one of the fields, just
enter the value you want to select for (in this case 2005)
in the criteria row under the field your want to check
(CurrentYear). There are many more sophisticated
expressions you can use in a criteria (e.g. <=2004) so play
around with it to get a feel for what you can do.

Thank you...that works just fine.

Jan