Hi there,
I have a table where columns are added frequently. I'd like to create a query, in Access, that only list some fields based on the field name. For instance, five columns are prefixed with "MS04", like MS04-011 and MS04-012. The query should build the results table dynamically and should only contain fields that begin with MS04.
Thanks!
I have a table where columns are added frequently. I'd like to create a query, in Access, that only list some fields based on the field name. For instance, five columns are prefixed with "MS04", like MS04-011 and MS04-012. The query should build the results table dynamically and should only contain fields that begin with MS04.
Thanks!