Search results

Thanks again Namliam. I forgot to mention one caveat I have in the my data. My data starts on 9/9/2013, so my Week 1 is considered to be 9/9/2013, not the 1/1/2013. Therefore, I have the week count info in a lookup table. I believe a SQL query should be able to do this, but still can't pull it...

Thanks Namliam for your reply. I just don't want to do any processing in Excel and have all computations, lookups, etc built into Access. If I understand what you are saying correctly, get rid of the week_count lookup table and have a function to append the week count in the same table, am I...

Hi, I am trying to automate a data match I've been doing in Excel into Access. Basically, I have 2 spreadsheets: 1. First has a "Start Date" for each user 2. Second spreadhsheet is a lookup table with 2 fields: Week Start Date and Week #. In other words, Dec 30 - Week 1, Jan 6 - Week 2, Jan...

Hi, I haven't used Access for years and I am here to get some feedback to some of my questions from experts. Thank you Burak