Querying on Alias field

Nicole McMorrow

I am trying to run a query that contains records for which a specific Alias Type = Blank...possible?

Mark Guncheon

That's it in the query: Alias type = blank.

Nicole McMorrow

That seems to apply the criterion of blank to all Alias Types. I'm looking for blanks on a specific Alias Type.

Mark Guncheon

Then your query has as its criteria:

alias type = the type you are looking at

alias = blank

JoAnn Strommen

Did you get what you need?

Alias seems to be a bit different for querying on. When you select Blank you lose option to specify a type. You may need to use Alias Type > does not equal > specific type.


If that doesn't work, i would do a query of records with that alias type. Do a query of all records ( no criteria or output) then merge the all records query SUB the query of those with that alias. Voila - you have the records without it.

Nicole McMorrow

Thank you, JoAnn and Mark. I think I am able to get what I need!