Recent content by Mr0utside

  1. M

    Access Split Date Range into individual Records

    Hello Frothingslosh Thank you so much for your assistance i will be trying this out on Monday :D Will let you know how it goes! Again thanks for your assistance :D
  2. M

    Access Split Date Range into individual Records

    Hello Frothingslosh Thank you for your response. That is exactly what i need to do ! It seems that i have the same situation because the system that i need to feed the data to also requires individual entries. I would appreciate it if you could share your code ! Thanks so much for the assistance
  3. M

    Access Split Date Range into individual Records

    Hi can anyone please assist this is really important
  4. M

    Access Split Date Range into individual Records

    I have only written code in Excel. But i do not know how vba works in access. I know how to program for, do while and do until loops but i have never done these in access let alone created records in access based on code. If you could help me in creating the code that would be great :)
  5. M

    Access Split Date Range into individual Records

    Hello MarkK, Thank you for your responses so far. Beside cross referencing the information which is a validation process that i do. This data is also uploaded to a tool, and currently i am doing it manually item by item and it takes a lot of time since i know this could be automated. The system...
  6. M

    Access Split Date Range into individual Records

    Hello The reason i need a day by day instance of each item is so it can be cross referenced later on with other raw data's that also come in a day by day instance. Say for example if the attendance table ( in day to day format) says that you did not come to work on 1/1/2014 but that day the...
  7. M

    Access Split Date Range into individual Records

    Hello, i'm new to this forum and i was wondering if anyone could please assist with the following: have a db table in the following format Table Name: Absence_Entries_Detail Name--Abscence type--StartDate-- End Date Person 1 --Vacation -- 1/1/2014-- 1/4/2014 Person 2 --LOA --...
Back
Top Bottom