I have a table in Access 2003 called "GL Balances"
I would like to export this on a form to the below location but naming the file with "Balances 03/03/2011" but i would like the date to change each day. So its like excel =WORKDAY(Today(),-1)
G:\Asset Services MI\UnMatched Merit\Balances
Does anyone have the code to achieve this?