Need help with recordset
Our club membership database allows for one or two members per account (record)
So our member_accounts table has columns…
Membership_ID, FirstNameM1, LastNameM1, StatusM1, FirstNameM2, LastNameM2, StatusM2, address, city, state, zip, ...other stuff.
I need a help creating a single recordset that would produce the following results
If StatusM1 =”regular” and StatusM2 =”regular” the results would be…
FirstNameM1, LastNameM1, FirstNameM2, LastNameM2, address, city, state, zip
If StatusM1 =”regular” & StatusM2 <> ‘regular” (anything other than “regular”) the results would be…
FirstNameM1, LastNameM1, (null), (null), address, city, state, zip
Some day I would like to have the skills to split off the individual member data into it's own table with a relationship to the account table.