mmda1 Posted May 5, 2015 Report Share Posted May 5, 2015 Como posso fazer no access a seguinte função do SQL? CASE WHEN DT.data_AAAAMMDD IN ('20150416','20150521','20150618','20150716','20150820','20150917','20151015','20151119','20151217') THEN 'DIA AÇÃO' ELSE 'DIA NORMAL' END OBRIGADA Quote Link to comment Share on other sites More sharing options...
0 mmda1 Posted May 12, 2015 Author Report Share Posted May 12, 2015 Pessoal, alguém consegue me ajudar? Quote Link to comment Share on other sites More sharing options...
0 MrMALJ Posted May 25, 2015 Report Share Posted May 25, 2015 Boa tarde, o access aceita normalmente qualquer expressão em MS-SQL inclusive o case, veja o link abaixo. https://msdn.microsoft.com/pt-br/library/ms181765.aspx Quote Link to comment Share on other sites More sharing options...
Question
mmda1
Como posso fazer no access a seguinte função do SQL?
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.