Search results

  1. W

    Multiple updates in single query

    All, How can I run multiple update statements that join to other tables, using 1 sql script? Here is the query I have now that is failing.. Ideas? UPDATE EXCEPTION SET [exception].[assigned to] = [UserInfo].[Name] IIF( [exception].[Assigned_to_id] = [UserInfo].[id]), IIF(...
  2. W

    updating text field from integer field conversion

    Hi all, I have 2 tables, on the 1 table, I have a field I need updated from another field in another table.. so tbl1.field1 needs to be tbl2.field2 both are text fields. The problem I'm faced with is that my criteria is the following.. tbl1.field1=tbl2.field1 tbl2.field1 is a number field...
  3. W

    Finding table names

    Hi all I have an issue where I'm trying to find an id in a table and then also pull back that table name the id is in.. I have about 6 tables in my database, I have to search through each table looking for an ID value.. I would like to be able to have my query retrieve the ID as well as the...
  4. W

    IIF statement to execute select query when true and false

    I was wondering if it was possible to write an IIF query, that depending on the day of the week it would execute specific select queries that I could then return in a subreport form. something like: IIF(WEEKDAY(DATE,2),<ON TRUE RUN SPECIFIC SELECT>, <ON FALSE RUN A DIFFERENT QUERY>); Then...
  5. W

    Select where field display is a %

    Hi, I have a table with a number field that is set to display as a %.. (ie.. 100 displays as 100.00% when the column is selected).. I want to not see where the value = 100.. my query ---------- SELECT [SmartAdvisor Infrastructure Request List].[% Complete] FROM [SmartAdvisor...
Back
Top Bottom