RE: Query Help

If i am not wrong your query will look like this

SELECT isnull( PROPERTYTYPE,'X'), INDUSTRY, ORGNAME
FROM ORGANIZATION
WHERE (INDUSTRY LIKE '51%')
ORDER BY INDUSTRY

'X' - number provided by you

"Steve1445" ने लिखा:

> Here is what I am trying to do.
>
> I need to query a table like this:
>
> SELECT PROPERTYTYPE, INDUSTRY, ORGNAME
> FROM ORGANIZATION
> WHERE (INDUSTRY LIKE '51%')
> ORDER BY INDUSTRY
>
> I provide the variable, in this case a range of numbers from the Industry
> column starting with 51. This returns three columns of data, which two out
> of three are populated. The field propertytype is most likely empty. If it is
> empty I want the query to fill all the empty spots with another number I
> provide. If its not empty, then I want to leave it alone.
.

Relevant Pages

  • Re: Count Problem
    ... Try saving this query as, say, qryIntermediary: ... SELECT Industry, Sum(SumOfCosts) As Costs, CountAs NoOfCustomers ... GROUP BY Industry, Customer) AS Subquery ...
    (microsoft.public.access.queries)
  • RE: Query returning many duplicate records
    ... If you wanted to calculate the number of establishments in a particular ... Then, in the query you would add the Industry column, and the ... "Roberto" wrote: ...
    (microsoft.public.access.queries)
  • RE: Query Help
    ... > If i am not wrong your query will look like this ... > SELECT isnull, INDUSTRY, ORGNAME ... The field propertytype is most likely empty. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Query Improvement
    ... INDUSTRY: Index on IND_ID column. ... query you do not use a NVL function for the join. ... Even in older versions it should help to write it as an equijoin without IN or EXISTS and let the CBO decide about the driving table. ...
    (comp.databases.oracle.server)
  • Re: How not to display similar records in a subform?
    ... of Position Types or any combination of either, so are a necessary criteria. ... > If Industry and Position Type are not germane, ... > include them in the query? ...
    (microsoft.public.access.forms)