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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  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, 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]...
  4. 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...
  5. 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])...
  6. 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]...

Part and Inventory Search

Back
Top