RE: Query Help

close, but you got me on the right track, here is what I came up with using
yours as the base:

UPDATE ORGANIZATION
SET PROPERTYTYPE = '45321'
WHERE (INDUSTRY LIKE '5112') AND (PROPERTYTYPE IS NULL)

Thanks!

"priya.H.Gupta@xxxxxxxxxxxxxxx" wrote:

> 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

  • Query Help
    ... SELECT PROPERTYTYPE, INDUSTRY, ORGNAME ... The field propertytype is most likely empty. ... empty I want the query to fill all the empty spots with another number I ...
    (microsoft.public.sqlserver.mseq)
  • Conditional Formatting
    ... If A2 is empty or does not equal named range "Industry ... If B2 is empty or does not equal named range "ClientType" ...
    (microsoft.public.excel.worksheet.functions)
  • 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: 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)