MS ACCESS_My question

  dregn 14:48 08 Mar 2006
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 2006

John,

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

Den

  Kenneth-266656 15:13 08 Mar 2006

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 2006

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.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?