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
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
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 :)
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...
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...
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 --...