I'm stuck in a bit of a problem. I've got a table called sales with a date field in it, but the date is not in the date format, its in the number format and it's too late to change it as the table's got over 70,000 records in it and I also don't have administrative right to change the date. So the date comes up as 20000025. I've got records from 1999 to present date 2006. The problem I'm having is that I need to group the data according to year corresponding to Japanese calendar (example 1/04/05 to 31/0306).
I've already spent a lot of time but can't find any solution. I'm using access 2000 file format. Please help.