Hi,
As I am not able to search with the Forum, please let me know if my question has already been asked and answered.
I am quite rusty in using Access 2007, I'd like to get some help in finding a specific date is within a given date range.
E.g., Mr A in Australia and Mr B in China are taking leave from 23rd Dec to 8th Jan. I want to find out how many days are for Public Holidays accordingly.
I have a staff table has a field called location, I also have a PH table has date and location fields.
What would be ideal is, when I enter 23rd Dec and 8th Jan for Mr A and Mr B in database, PH dates can be automatically populated to next record.
Am I asking too much from Access?
Thanks heaps.
Jenny
As I am not able to search with the Forum, please let me know if my question has already been asked and answered.
I am quite rusty in using Access 2007, I'd like to get some help in finding a specific date is within a given date range.
E.g., Mr A in Australia and Mr B in China are taking leave from 23rd Dec to 8th Jan. I want to find out how many days are for Public Holidays accordingly.
I have a staff table has a field called location, I also have a PH table has date and location fields.
What would be ideal is, when I enter 23rd Dec and 8th Jan for Mr A and Mr B in database, PH dates can be automatically populated to next record.
Am I asking too much from Access?
Thanks heaps.
Jenny