MS ACCESS_My question

  dregn 14:48 08 Mar 06
Locked

I am novice user of MS Access and have built a table showing all members of a group. I wish to create a separate report of those members who have not yet renewed their subs.
How do I go about this, please?
Advice appreciated.

  dregn 14:59 08 Mar 06

John,

Many thanks for that and I'll have a go later today.
Much appreciated.

Den

  Kenneth-266656 15:13 08 Mar 06

Create a field in the main members list called subs with a Yes/No data type check box in the form of a tick. If the box is ticked the member has paid - if unticked the member has not paid. You can then create a query showing subs - members name - and if necessary address and showing Yes as the criterea in design view

  dregn 16:12 08 Mar 06

Torwalker

Thanks for your helpful suggestion.
I will apply these techniques this evening.

Many thanks.

Den

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Prehistoric Britain is laid out in these Royal Mail stamp illustrations

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…