Hi everyone in the forums
Not sure where this thread needs to go, it falls into a number of camps I believe!
I have built a database and got all the functionality working (importing data, updating the system etc.) and now come to a head scratcher with the reports which is my least favourite part of Access.
I have a swictchboard with 7, yes 7 criteria to generate a report from a single table. Is there a clean way I can create a query at runtime without resorting to what I can only describe as the the mother of all IF...THEN statements?
The criteria is Name (text) , Main Membership Status (text), Second Membership Status (text), Year Joined (text), Year Left (text), Retired (yes/no), Contactable (yes/no)
The year joined / year left is a text field here as other info is held in the field with the year at the end encapsulated in brackets.
Any and all help will be thankfully received and gratefully applied!
Not sure where this thread needs to go, it falls into a number of camps I believe!
I have built a database and got all the functionality working (importing data, updating the system etc.) and now come to a head scratcher with the reports which is my least favourite part of Access.
I have a swictchboard with 7, yes 7 criteria to generate a report from a single table. Is there a clean way I can create a query at runtime without resorting to what I can only describe as the the mother of all IF...THEN statements?
The criteria is Name (text) , Main Membership Status (text), Second Membership Status (text), Year Joined (text), Year Left (text), Retired (yes/no), Contactable (yes/no)
The year joined / year left is a text field here as other info is held in the field with the year at the end encapsulated in brackets.
Any and all help will be thankfully received and gratefully applied!