Search results

Hi experts, I'm baffled with an application I have created in Access2000 as it works (runs under RunTime) perfectly on all XP's at the office, on the Win7 pc but not on a Win7 notebook! The menu, startup form etc does not show at all. Where should I look or what should I trace? Any advice...

That yields 200054 :-)

@ plog As a followup I found out about your getweeknum function, added to a module and made a small modification which I think will prove better in my case. Modified code is: .... If (WeekNum = 53) And (YearNum Mod 4 > 0) Then ' if WeekNum is 53 and not leap year, rolls over return value to...

Hi plog, Thank you for responding. In the mean time I managed to solve my problem, or so it seems. I still need to evaluate the results in detail. It took 4 queries to get what I need: I collect all info I need with the first query(trz_base), I get my week totals in the second, where it starts...

Hi experts, I have managed to include a "cumulative total" column to my query but with a problem which I hope someone can point me in the right direction. Here's what I need to achieve: My data starts relatively in 3rd quarter of any given year and ends approximately in 2nd quarter of the...