Search results

  1. A

    Solved Group by

    I have a problem. I have two identical ids which should merge into one when using a query with group by. Unfortunately it does not work. How to remove invisible characters in an access file and make them fold?
  2. A

    Query left join

    Hi, I have a problem. I need to join two tables with a query. A need all information from table 1 and Value for every ID from table 2 - but only from max available year. How to do it? Table 1 id name 1 A 2 B 3 C 4 D 5 E Table 2 id year value 1 2020 100 1 2019 50 1...
  3. A

    How to add null handling condition in function

    Hi, I have function. How correctly add condition: case isnull then "no data"? Option Compare Database Public Function AssignGrade(studScore As Single) As String Select Case studScore Case 0 To 100 AssignGrade = "A" Case 101 To 200 AssignGrade = "B"...
Top Bottom