Access Report

[AlantheSec]

I have a members DB that apart from full details also show payments of yearly subscriptions. i am trying to print a report that shows a list of all the lapsed members. sounds like a simple simple report, BUT...I have a table that includes male and female members on one club number, idealy man and wife, but if for some reason the part company one may not pay the others subs those making the other a lapsed member. is there anyway i can print one part without the other?

eg. this is haw it prints now

Male Name Paid Female Name Paid
J Smith No M Smith Yes

and this is what i am after

Male Name Paid Female Name Paid
M Smith Yes

 

[rzw0wr]

I would split the table. Separate the husband(partner A) and wife (partner B)
I see many problems down the line if people are not married or divorce and get remarried.

See http://symplebyte.com/microsoft_office/access/how_to_normalize_data_access.html

Dale