Recent content by Anetal

  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

    For id=2 , max year should be 2020 and value for this year 1000. In query year is 2020 and value 100.
  3. A

    Query left join

    Thank you very much. I tried the sample data method but got the wrong result. I am attaching a file
  4. 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...
  5. A

    How to add null handling condition in function

    Thank you very much. Now it's ok =)
  6. A

    How to add null handling condition in function

    I have still error. I added a file.
  7. A

    How to add null handling condition in function

    I change this part and still doesn't work: Score Grade 0 A 10 A 2 A 200 B 100 A #Error #Error 10 A Option Compare Database Public Function AssignGrade(studScore As Single) As String Select Case Nz(studScore, -1) Case -1 AssignGrade = "n/d" Case 0 To 100...
  8. A

    How to add null handling condition in function

    Something doesn't work. For Score 0 I need Grade A For score null I need Grade "b/d" Kwerenda1 Kwerenda1 Score Grade 0 A 10 A 2 A 200 B 100 A #Error #Error
  9. A

    How to add null handling condition in function

    I need grade "n/d"
  10. 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"...
See more
Back
Top Bottom