Search results for query: *

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...

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...

thanks i got this figured out

Thanks all for the help! I figured it out!

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...

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...

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...

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]...

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...

I figured it out , thanks

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])...

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())

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]...