i have a record field called FULLNAME that looks like the following:
however, not all records have a Partnumber indicated since they may be the parent.
I would like a query that will separate them as follows, taking into account that the partnumber field may be blank/null
Category Division Manufacturer PartNumber
Sales Tools Acme null
Sales Tools Acme abc
Sales Tools Zenith null
Sales Tools Zenith 123
I prefer ONE query instead of a separate query to extract each divisor..
help is appreciated.