Expiration in Access
- Thread starter jealindgar
- Start date
jealindgar
JLGarcia
- Local time
- Today, 22:48
- Joined
- Aug 5, 2007
- Messages
- 35
You do not have to make that effort, do not worry. I thank you.
GPGeorge
George Hepworth
- Local time
- Today, 14:48
- Joined
- Nov 25, 2004
- Messages
- 2,845
There are some serious hurdles to overcome here because of the vriable business rules.
Cuando veo terminos como "a veces", me parece que hay una problema.
¿Por que sera que a veces se incluya a Lunes, y no se incluya en otra ocasiones?
¿Cuando se incluya al mes de Agosto, y cuando no se incluya Agosto?
Si se puede dar una reglas, se puede criar a los codigos, pero necesitamos saber estas reglas.
Otra cosa.
Cada municipalidad tiene un calendario de dias libres distintos, ¿verdad? Me parece que tendras que modificar el Table Festivos, or criar otro table de municipalidades conjunto con Dias Festivos.
Explica me las reglas de dias Festivas distintas, por favor.
Cuando veo terminos como "a veces", me parece que hay una problema.
¿Por que sera que a veces se incluya a Lunes, y no se incluya en otra ocasiones?
¿Cuando se incluya al mes de Agosto, y cuando no se incluya Agosto?
Si se puede dar una reglas, se puede criar a los codigos, pero necesitamos saber estas reglas.
Otra cosa.
Cada municipalidad tiene un calendario de dias libres distintos, ¿verdad? Me parece que tendras que modificar el Table Festivos, or criar otro table de municipalidades conjunto con Dias Festivos.
Explica me las reglas de dias Festivas distintas, por favor.
GPGeorge
George Hepworth
- Local time
- Today, 14:48
- Joined
- Nov 25, 2004
- Messages
- 2,845
Pues, creo que tengo una solucion.
El idea es que el table "tblFestivas" debe tener una columna por Municipio para que se peude indicar si qualqiuer dia libre o dia Festiva se aplica a cada Municipio. Ademas, se puede indicar que cada dia del mes de Agosto (1 a 31) es un dia Festiva por qualqier Municipio. En ese manera no se debe tener codigos extras para Agosto. Solucionnes asi, que se dice "table-driven" son mas facil a mantener.
Las Funciones que usaba son "fNetWorkDays" y "fAddWorkDays" de Brent Spaulding, "datadrenaline". Yo hice unas modificaciones pequeñas para el "IdMunicipio".
En esta base de datos, hay un query nuevo lo qual es basada en este funcion. Espero que te ayuda.
George
El idea es que el table "tblFestivas" debe tener una columna por Municipio para que se peude indicar si qualqiuer dia libre o dia Festiva se aplica a cada Municipio. Ademas, se puede indicar que cada dia del mes de Agosto (1 a 31) es un dia Festiva por qualqier Municipio. En ese manera no se debe tener codigos extras para Agosto. Solucionnes asi, que se dice "table-driven" son mas facil a mantener.
Las Funciones que usaba son "fNetWorkDays" y "fAddWorkDays" de Brent Spaulding, "datadrenaline". Yo hice unas modificaciones pequeñas para el "IdMunicipio".
En esta base de datos, hay un query nuevo lo qual es basada en este funcion. Espero que te ayuda.
George
Last edited:
jealindgar
JLGarcia
- Local time
- Today, 22:48
- Joined
- Aug 5, 2007
- Messages
- 35
You are taking too much trouble for me and I appreciate it greatly.
This works as follows (excuse my English as run over):
Indeed, each municipality has its own holidays, but there are other holidays that corresponds to the island (Gran Canaria), that is, for all municipalities.
The problem is that for all years, I have to include all public holidays (eg 08/09/2010, 08/09/2011, 08/09/2012, etc.).. But I had this, therefore, is not a serious problem.
Certainly there are many holidays that don´t have a particular day, that is, a holiday may on the first Monday of the week (for example), and perhaps next year, on a Tuesday (but that, on rare occasions).
The problem is when it's August. I have expiration that have the month of August, and that doesn´t include other expiration in August (and I mean the whole month).
For example:
The court gives me 10 days to formalize an appeal from the July 26, in a civil matter. So if we have 10 days from July 26, my last day to file this appeal, it would be September 10th (no Saturday or Sunday, and Sept. 8 is a holiday here).
But now suppose I have to file that appeal to the City, then ending the day on August 6 (Monday to Saturday) on Saturday and obviously did not work (nor do they collect appeals), so the last day, really, would Friday August 5.
Here two conditions are met: include Saturdays and August.
The problem is not always one hundred percent. So the solution I've toyed with is the right way. Using buttons, choose me, the best combination (whatever the topic).
Anyway, who would I choose, I prefer mature or is it better for me, deadlines are:
* Monday through Friday counting holidays (local and general. I have another field to municipalities), and with or without Augusts;.
* Monday to Saturday counting holidays (local and general), and with or without August;
* Monday to Sunday counting holidays (local and general), and with or without August;
WOW!!!
This works as follows (excuse my English as run over):
Indeed, each municipality has its own holidays, but there are other holidays that corresponds to the island (Gran Canaria), that is, for all municipalities.
The problem is that for all years, I have to include all public holidays (eg 08/09/2010, 08/09/2011, 08/09/2012, etc.).. But I had this, therefore, is not a serious problem.
Certainly there are many holidays that don´t have a particular day, that is, a holiday may on the first Monday of the week (for example), and perhaps next year, on a Tuesday (but that, on rare occasions).
The problem is when it's August. I have expiration that have the month of August, and that doesn´t include other expiration in August (and I mean the whole month).
For example:
The court gives me 10 days to formalize an appeal from the July 26, in a civil matter. So if we have 10 days from July 26, my last day to file this appeal, it would be September 10th (no Saturday or Sunday, and Sept. 8 is a holiday here).
But now suppose I have to file that appeal to the City, then ending the day on August 6 (Monday to Saturday) on Saturday and obviously did not work (nor do they collect appeals), so the last day, really, would Friday August 5.
Here two conditions are met: include Saturdays and August.
The problem is not always one hundred percent. So the solution I've toyed with is the right way. Using buttons, choose me, the best combination (whatever the topic).
Anyway, who would I choose, I prefer mature or is it better for me, deadlines are:
* Monday through Friday counting holidays (local and general. I have another field to municipalities), and with or without Augusts;.
* Monday to Saturday counting holidays (local and general), and with or without August;
* Monday to Sunday counting holidays (local and general), and with or without August;
WOW!!!
GPGeorge
George Hepworth
- Local time
- Today, 14:48
- Joined
- Nov 25, 2004
- Messages
- 2,845
You will need to maintain the table of dias Festivas for all municipalities, for each year. There really is no simpler approach, IMO.
"there are other holidays that corresponds to the island (Gran Canaria), that is, for all municipalities."
Make one entry for each holiday for each municipality. If there are 25 municipalities, there will be 25 entries for that holiday.
===
Cada dia Festiva debe tener un record en el tblFestiva por cada municipio donde se observa este dia. Si hay 25 municipios, y cada municipio observa tal y tal fecha come dia Festiva, tendras 25 records con esta fecha, uno por cada municipio.
En esta manera, no se debe escribir mas codigos. Solamente tienes que mantener al tblFestivia.
Y, como ya explique, por el mes de Agosto, lo mas facil es tener UN RECORD POR CADA DIA DEL MES ( primero hasta triente-uno) por cada municipio donde se observa vacaciones en Agosto. Tendras mas records, pero es mucho mas facil mantener que excriber codigos especiales.
"there are other holidays that corresponds to the island (Gran Canaria), that is, for all municipalities."
Make one entry for each holiday for each municipality. If there are 25 municipalities, there will be 25 entries for that holiday.
===
Cada dia Festiva debe tener un record en el tblFestiva por cada municipio donde se observa este dia. Si hay 25 municipios, y cada municipio observa tal y tal fecha come dia Festiva, tendras 25 records con esta fecha, uno por cada municipio.
En esta manera, no se debe escribir mas codigos. Solamente tienes que mantener al tblFestivia.
Y, como ya explique, por el mes de Agosto, lo mas facil es tener UN RECORD POR CADA DIA DEL MES ( primero hasta triente-uno) por cada municipio donde se observa vacaciones en Agosto. Tendras mas records, pero es mucho mas facil mantener que excriber codigos especiales.
jealindgar
JLGarcia
- Local time
- Today, 22:48
- Joined
- Aug 5, 2007
- Messages
- 35
OK GPGeorge, about what you tell me, is there any example?
jealindgar
JLGarcia
- Local time
- Today, 22:48
- Joined
- Aug 5, 2007
- Messages
- 35
With regard to the holidays, I'll leave it as is. I care about the month of August. I had thought about adding the month, or not, by a check box.
GPGeorge
George Hepworth
- Local time
- Today, 14:48
- Joined
- Nov 25, 2004
- Messages
- 2,845
Here is the previous upload that includes the code to calculate dias Festivas. YOU DON"T NEED EXTRA CODE TO DEAL WITH AUGUST because you can add all 31 days in August to the holiday table for any municipio which takes August off. That way, all of your calculations are the same.
jealindgar
JLGarcia
- Local time
- Today, 22:48
- Joined
- Aug 5, 2007
- Messages
- 35
thanks a million GPGeorge, but the problem is that sometimes I do have to include August, so I need a check box (to decide whether to include or not, the entire month of August).
I can not consider as a holiday, ie, add 31 days on the festive table
I can not consider as a holiday, ie, add 31 days on the festive table
jealindgar
JLGarcia
- Local time
- Today, 22:48
- Joined
- Aug 5, 2007
- Messages
- 35
I've been blind. I was determined to add, specifically, in August and did not know how to give that order to Access.
But now I'm seeing from another point of view. This is not to add or subtract the month of August, trying to add or subtract a month (I have assumed that there is no need to tell Access that this is the month of August).
I mean, using a checkbox, to which I would call "August", subtract, or add to my ended day, 31 days.
but, how?
How do I explain that if you access to 31 days rest, I spend the next month? That is, if I have 10 days to file an appeal as of July 28 (excluding August), the correct date for filing the appeal either September 13.
But now I'm seeing from another point of view. This is not to add or subtract the month of August, trying to add or subtract a month (I have assumed that there is no need to tell Access that this is the month of August).
I mean, using a checkbox, to which I would call "August", subtract, or add to my ended day, 31 days.
but, how?
How do I explain that if you access to 31 days rest, I spend the next month? That is, if I have 10 days to file an appeal as of July 28 (excluding August), the correct date for filing the appeal either September 13.
