Is there a function similar to excels vlookup that would allow fiscal months to be found from a date, within access.
I was using excel to do this by now have 80000 lines of data so have moved the data into access and create a pivot table from within excel.
In excel I had a lookup table and used an non exact match to return the fiscal month.
Can't see how to do that in an access query/calculation - but am fairly new to access.
Thanks a lot
I was using excel to do this by now have 80000 lines of data so have moved the data into access and create a pivot table from within excel.
In excel I had a lookup table and used an non exact match to return the fiscal month.
Can't see how to do that in an access query/calculation - but am fairly new to access.
Thanks a lot