J
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.
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.