TrainSignal's Heather Ackmann introduces Microsoft Access functions, showing how date and time functions can be used to automate data entry, and how to leverage date functions to limit query results to a specific month and year.
thank you very much i have a question in your exercise how if i want to show contacts with transaction date after or before specific year lets say we want to show contacts after 2010 i tried to write in criteria > or < and its not working .. so could you tell me what to write please
I have been trying to calculate the number of working days between two dates, which excludes holidays and weekends. what function in ms access executes this task. in excel it's the networkdays function. kindly assist. thank you
