Hello everyone! I have a problem trying to get a user to be able to query the database with only the fields and specifics they want.
User logs in, browses through record entries and then wants to see how many of the entries are under the age of 21 and instead of seeing every field in the database they just want to see the first name, last name, and of course the age.
I was thinking of having a CommandButton that brings up a form with checkboxes (to select the fields) and text boxes(to input numbers or text) and radio buttons (greater than, less than). But even after building the form I don't know the VB code to do anything that advanced.
Hopefully I explained this well enough. Thanks in advance!