The database tables currently in use exist to support a form -- that is the end result of the data. However, there exists a need to see in the aggregate which students have websites. How do I exclude the blank fields in the query? I thought I could simply sort that field's column, but the software won't allow the hyperlinked fields to be sorted in ascending/descending order.
Let me clarify that to say the query allows for the sort, but not the table. But, the bigger goal is not about sorting but about suppressing the blank fields from appearing in the query so the query shows ONLY those students who have websites.
Thanks!