Recent content by Butter

It's easy enough to link to someone else's Excel spreadsheet and get their data into my Access database but I have to do it each month. They create a new tab each month (OCT-2007,NOV-2007,DEC-2007) for the month and the spreadsheets always have the same structure. Is there anyway to tell my...

Thanks! The function...Right([fieldname],5)...did exactly what I needed. Thanks for pointing in the right direction.

I'm new to this so here goes...I've got an Access query that I'm trying to remove the first 5 characters from the 10 character name in each record. The name is composed of both letters and numbers. The first 5 characters vary but it is always the first 5 that need to go. Thanks in advance!