MonthOverMonth - Month-Over-Month in Microsoft Access


	Back to Month-Over-Month Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

MonthOverMonth

Kevin Robertson

5 years ago

Richard,
In your Month-Over-Month Template some of the figures seem to be wrong as highlighted in the screenshot below. Or am I just going mad? lol

	Kevin Robertson OP @Reply 5 years ago

	Richard Rost @Reply 5 years ago
I'll definitely look into this. I wonder if it's a problem because of the date format.

	Scott Axton @Reply 5 years ago
I was wondering the same thing. When he mentioned that his version of office accepted the semicolon. Is the international version different as far as VBA is concerned? Kevin you may have some insight. Or even Alex.

	Richard Rost @Reply 5 years ago
Yeah different regional settings IN WINDOWS will change the way Office behaves. I just recreated his query with his data and it works fine for me.

	Richard Rost @Reply 5 years ago
Your data works perfectly for me, Kevin. Let me see your table data. I'm still thinking it's a regional settings problem.

	Richard Rost @Reply 5 years ago

	Kevin Robertson OP @Reply 5 years ago
Yeah. I just changed my regional settings and got completely different results.

	Richard Rost @Reply 5 years ago
Yeah... I'm not an expert when it comes to regional settings. I've never played with non-US data. Sorry. You found the missing link in my armor. :)

	Richard Rost @Reply 5 years ago
I'm going to move this thread to the month-over-month page so others can see it too.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Month-Over-Month.

Next Unseen

New Feature: Comment Live View