Search between Access Dates for Holidays

Asked

Viewed 52 times

1

inserir a descrição da imagem aqui

I’m having difficulty inserting a search in MS Access to score if a collaborator is on vacation, I’m inserting the following formula:

Status_: SeImed([Data_] Entre [DT INI GOZO_] E [DT FIN GOZO_];"Ferias""Ativo") 

But the result is jumping from Data Início and going to Data Fim, between the dates is giving as if the collaborator is Ativo, but the same is Férias.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.