Ignoring a, an, the when creating a sort or filter

**DeadWaxDatabase** · 10-17-2021, 05:14 PM

Greetings to all -
I use Access to catalog my lp collection, and would like to be able to enter titles, artists, etc. as they appear, without having to move the words "a," "an," or "the" to the end of a field.
How can I do this?
DeadWaxDatabase

**queuesef** · 10-18-2021, 08:47 AM

create a helper column/field where you exclude those words. Run queries on Helper column

**alansidman** · 10-19-2021, 11:19 PM

Are you doing this with a parameter? If so then use the wildcard * before and after the primary words in your search with the function Like

Ignoring a, an, the when creating a sort or filter

LinkBack

Thread Tools

Rate This Thread

Display

Ignoring a, an, the when creating a sort or filter

Re: Ignoring a, an, the when creating a sort or filter

Re: Ignoring a, an, the when creating a sort or filter

Thread Information

Users Browsing this Thread

Similar Threads

Creating a VBA script to sort a selected group via custom sort.

Need help with creating a macro that filter, sort, and copy data onto new worksheet.

[SOLVED] creating a formula to sort names from one column's results and sort them based on another

Automatically Ignore/Filter/Sort Blanks from a Pivot Table before creating Chart Using VBA

Ignoring leading characters in a sort

Bookmarks

Bookmarks

Posting Permissions