Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by joycesolomon

  1. joycesolomon

    Filter record based on multi-selection of combo box and text boxes

    Hi, Need some help/directions/suggestions as to how i can accomplish the below: I have 4 comboboxes and two text boxes...the text boxes will need to carry dates...start date and end date I want to be able to filter records based on different probability eg. 1.combobox1 with value and just a...
  2. joycesolomon

    Multi Level User Login

    Hi, I have a project with Access frontend and SQL as the database. I need to create a login screen with 4 level of users (admin, creator, contributor, and visitor). I have not done this before....and of course each level can do different manipulation with different forms. Can someone please...
  3. joycesolomon

    Order By Statement, help please

    thanks i got this figured out
  4. joycesolomon

    Order By Statement, please help

    Thanks all for the help! I figured it out!
  5. joycesolomon

    Order By Statement, please help

    Glenn, If i have two CASE statement like this, how to combine them? <code> CASE WHEN [Last Name] IS NULL THEN CASE WHEN [First Name] IS NULL THEN [Company] ELSE [First Name] END ELSE CASE WHEN [First Name] IS NULL THEN [Last Name] ELSE [Last...
  6. joycesolomon

    Order By Statement, please help

    Would this be a correct one then? <code> ORDER BY CASE WHEN [Last Name] IS NULL THEN CASE WHEN [First Name] IS NULL THEN [Company] ELSE [First Name] END ELSE CASE WHEN [First Name] IS NULL THEN [Last Name] ELSE [Last Name] + ',' + [First Name] END END ELSE CASE WHEN...
  7. joycesolomon

    Order By Statement, please help

    Here is something that i am trying to convert from the Access Query Access Query: SELECT IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])) AS [File As], IIf(IsNull([Last Name]),IIf(IsNull([First...
  8. joycesolomon

    Order By Statement, please help

    Hi I have the below order by statement ORDER BY CASE WHEN [Last Name] IS NULL THEN CASE WHEN [First Name] IS NULL THEN [Company] ELSE [First Name] END ELSE CASE WHEN [First Name] IS NULL THEN [Last Name] ELSE [Last Name] + ',' + [First Name]...
  9. joycesolomon

    Order By Statement, help please

    Hi I have the below order by statement ORDER BY CASE WHEN [Last Name] IS NULL THEN CASE WHEN [First Name] IS NULL THEN [Company] ELSE [First Name] END ELSE CASE WHEN [First Name] IS NULL THEN [Last Name] ELSE [Last Name] + ',' + [First Name] END END...
  10. joycesolomon

    CASE Statement in t-SQL

    I figured it out , thanks
  11. joycesolomon

    CASE Statement in t-SQL

    Hi , I have an Access SQL as this: SELECT IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])) AS [File As] Which i converted to A CASE statement in SQL: SELECT CASE WHEN IsNull([Last Name, 0])...
  12. joycesolomon

    Access Query to SQL

    can you please give me an example of a case statement? eg: IIf([Status]<>"Completed" And Int([Due Date])<Int(Date) is it right to say: CASE WHEN Status <> 'Completed' End And (CONVERT(varchar, [Due Date], 101) < GETDATE())
  13. joycesolomon

    Access Query to SQL

    Hi I am new to Microsoft SQL server database. Can someone please coach me how to conver the below Access query to SQL SELECT IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])) AS [File As]...
See more

Part and Inventory Search

Back
Top