J
jonwongfanclub
HI! I had a question regarding Microsoft Access and I figured I'd ask
the users of the program! I haven't used it much myself, just some
MySQL. I was wondering if you can create a database in Access but to
have some sort of SORT BY function or FILTER to sort out the
information. Like if my files are numerically based such as:
123-45-678
123-45-670
123-45-700
123-45-500
and then I wanted to sort the items by the last 3 digits for example.
Is there a way to do that in Access? Would I need to create a separate
field to input the last 3 digits in order for it to work? Or is there
a parse function that can take those last 3 digits and then sort them?
Or is MS Access cool enough that it can do it for me if I set it up
right? Thanks!
the users of the program! I haven't used it much myself, just some
MySQL. I was wondering if you can create a database in Access but to
have some sort of SORT BY function or FILTER to sort out the
information. Like if my files are numerically based such as:
123-45-678
123-45-670
123-45-700
123-45-500
and then I wanted to sort the items by the last 3 digits for example.
Is there a way to do that in Access? Would I need to create a separate
field to input the last 3 digits in order for it to work? Or is there
a parse function that can take those last 3 digits and then sort them?
Or is MS Access cool enough that it can do it for me if I set it up
right? Thanks!