I have a combo box on a form
SELECT [qryTTT Media].Company_ID, [qryTTT Media].CompanyName, [qryTTT Media].Market
FROM [qryTTT Media]
WHERE ((([qryTTT Media].[Bill_ID].[Value])=8))
ORDER BY [qryTTT Media].Market, [qryTTT Media].CompanyName;
The box displays CompanyName and [qryTTTMedia].Market. Some of the companies don't have an associated Market, so the sort order lists all of those first. Most of the time, I want a company with an associated Market (those are all Radio and TV Stations).
I'd like the box to zoom to the first item that has a value in the Market column. I want to keep the Market column as the first sort, but want to get to the first place in the list that actually has a Market in it. How do I accomplish that?
Any ideas?
MIB1019
SELECT [qryTTT Media].Company_ID, [qryTTT Media].CompanyName, [qryTTT Media].Market
FROM [qryTTT Media]
WHERE ((([qryTTT Media].[Bill_ID].[Value])=8))
ORDER BY [qryTTT Media].Market, [qryTTT Media].CompanyName;
The box displays CompanyName and [qryTTTMedia].Market. Some of the companies don't have an associated Market, so the sort order lists all of those first. Most of the time, I want a company with an associated Market (those are all Radio and TV Stations).
I'd like the box to zoom to the first item that has a value in the Market column. I want to keep the Market column as the first sort, but want to get to the first place in the list that actually has a Market in it. How do I accomplish that?
Any ideas?
MIB1019