Results 1 to 2 of 2
  1. #1
    Anetal is offline Novice
    Windows XP Access 2016
    Join Date
    Jan 2021
    Posts
    6

    Jak dodać warunek do funkcji z null

    Cześć


    mam taka funkcję.

    Potrzebuję dodać jeszcze warunek, że jeżeli wartość jest null to przypisz "brak danych".
    Jak to zrobić?

    Option Compare Database




    Public Function wyznacz(studScore As Single) As String


    Select Case studScore
    Case 1 To 5
    wyznacz = "do 5"
    Case 6 To 10
    wyznacz = "do 10"
    Case Else
    wyznacz = "pow 10"
    End Select
    End Function

  2. #2
    JoeM is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    3,900
    Foreign language, question posted multiple times.
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 10-07-2019, 10:46 AM
  2. Replies: 4
    Last Post: 04-09-2019, 02:05 PM
  3. Replies: 4
    Last Post: 03-11-2017, 09:48 PM
  4. Replies: 7
    Last Post: 11-07-2016, 09:24 AM
  5. Replies: 1
    Last Post: 02-23-2012, 02:27 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums