Iif and Switch in Access Queries

  Рет қаралды 11,437

codekabinett.com/en

codekabinett.com/en

Күн бұрын

Пікірлер: 12
@josephpatrick5381
@josephpatrick5381 Жыл бұрын
Structured way of explaining. New to MS Access and using Switch function. Thanking you for utmost details, which I might have overlooked.
@murtazaibrahim6560
@murtazaibrahim6560 3 жыл бұрын
Hours of learning in minutes... Thanks for uploading.
@wilsonfineart
@wilsonfineart 3 жыл бұрын
Great explanation. I use switch() but not often enough.
@patrickbevernage2919
@patrickbevernage2919 6 жыл бұрын
Perfect it is new to me, and certainly useful.
@ou812927
@ou812927 6 жыл бұрын
Love the Don Quixote shirt
@celsopereira9968
@celsopereira9968 6 жыл бұрын
Congrats for this class! Excellent! I have a question: Is this function available in every versions
@codekabinettcomen
@codekabinettcomen 6 жыл бұрын
Thank you for the feedback! Yes, I think the Switch function is in Access since Access 97! - A very long time.
@karldonaubauer6898
@karldonaubauer6898 4 жыл бұрын
@@codekabinettcomen It's actually worse, Philipp! ;-) Switch() is part of Access since version 1. I think it was 1.1. as Access Basic only came with that version. In 97 only the number of possible expression pairs was enhanced (from 7 to seemingly unlimited). Similar for its sister Choose(). 18 years ago I wrote a (German) article about this kind of stepchilds (access-im-unternehmen.de/VBAFunktionen__ausgewaehlte_Stiefkinder/). However, you are certainly right that even nowadays many people still don't know them and torture themselves with nested Iifs. I see this all the time in forum discussions.
@MarcosRieper
@MarcosRieper 4 жыл бұрын
thank you.
@neojumpy
@neojumpy 4 жыл бұрын
it would have been enough to move the line "big customer" after "Excellent Customer"
@codekabinettcomen
@codekabinettcomen 4 жыл бұрын
I would have been in this example. I still think Switch is more readable and easier to maintain for complex expressions.
@neojumpy
@neojumpy 4 жыл бұрын
@@codekabinettcomen i agree
Write SQL manually for Access
20:05
codekabinett.com/en
Рет қаралды 3,4 М.
The Basics of Error Handling in VBA
23:59
codekabinett.com/en
Рет қаралды 1,6 М.
Não sabe esconder Comida
00:20
DUDU e CAROL
Рет қаралды 56 МЛН
🕊️Valera🕊️
00:34
DO$HIK
Рет қаралды 16 МЛН
the balloon deflated while it was flying #tiktok
00:19
Анастасия Тарасова
Рет қаралды 34 МЛН
ЛУЧШИЙ ФОКУС + секрет! #shorts
00:12
Роман Magic
Рет қаралды 10 МЛН
Using Functions in Access Queries - Tutorial
19:54
codekabinett.com/en
Рет қаралды 25 М.
Iif, If Then Else, and Select Case in MS Access
13:02
Sean MacKenzie Data Engineering
Рет қаралды 20 М.
UNION Queries in SQL and Access
31:06
codekabinett.com/en
Рет қаралды 4,8 М.
Access iif statement (known as IF statement in Excel)
5:21
Alan Weaver
Рет қаралды 72 М.
Modern Charts in Access 2019 (and 2016/O365)
35:58
codekabinett.com/en
Рет қаралды 70 М.
20. (Advanced Programming In Access 2013) Using Tab Controls
21:26
Programming Made EZ
Рет қаралды 57 М.
40. VBA - DoCmd (Programming In Microsoft Access 2013) 🎓
37:27
Programming Made EZ
Рет қаралды 179 М.
Não sabe esconder Comida
00:20
DUDU e CAROL
Рет қаралды 56 МЛН