Hello my fellow coders!
I have an access database that. I would like to filter out some useless information without having to delete anything. The records are kept in a contactsTable, Class Registration Table, and Payments Table all are connected to a Registrations table. I have a couple of reports that I print from a form. This is where I want to filter out all of the previous classes from. I don't need this info and we offer so many classes that it's cluttering up our form and taking us longer to scroll down to the classes that haven't taken place yet. Can this be done? I'm thinking if statements but my programming knowledge of SQL or visual basic is rather small, so please help me in the right direction!
Any help is greatly appreciated.
I have an access database that. I would like to filter out some useless information without having to delete anything. The records are kept in a contactsTable, Class Registration Table, and Payments Table all are connected to a Registrations table. I have a couple of reports that I print from a form. This is where I want to filter out all of the previous classes from. I don't need this info and we offer so many classes that it's cluttering up our form and taking us longer to scroll down to the classes that haven't taken place yet. Can this be done? I'm thinking if statements but my programming knowledge of SQL or visual basic is rather small, so please help me in the right direction!
Any help is greatly appreciated.