RE: Year([due data]) causing problems in grouped report

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



By any chance is this Access 2003? If so, have you loaded service pak 3 and
all the patches and hotfixes? It sounds like that kind of problem because
=Year([due date]) should normally work.
--
Milton Purdy
ACCESS
State of Arkansas


"Michelle K." wrote:

I have a report that groups on a calculated field from the source query. The
calculated field is curryear=year([due date]). The database is in a shared
folder and is accessed by 15 other users through the network. The report has
been working wonderfully for 2 months and quite suddenly is not working on
about half of the computers -- and is right on the other half. Taking out
the group by curryear solves the problem. I'm also grouping by the week
number -- that still works. Any thoughts??
.



Relevant Pages

  • RE: MS defends MBSA
    ... >first have to check for patches and hotfixes for the tool that is ... The MBSA is a piece of software. ... scan my user's machines and check them for dubious MS Office security ...
    (Focus-Microsoft)
  • Re: SP2 - Why bother?
    ... > hotfixes or Service packs. ... These are all patches to fix errors. ... drivel in a Linux newsgroup.. ... problems problems problems.. ...
    (microsoft.public.windowsxp.general)
  • Re: Setup-CD (DEU) reduzieren
    ... HotFixes nach ..\i386 kopierten Dateien? ... und dabei Duplikate erkennen und verlinken lasse schrumpft dieses wegen ...
    (microsoft.public.de.german.win2000.setup)
  • RE: Help with XP Hotfixes and Patches
    ... hotfixes require a certain level of XP underneath (same as Win2K hotfixes, ... Help with XP Hotfixes and Patches ... > After installing I immediately went to Windows Update to try ...
    (Focus-Microsoft)
  • Re: Harden Server Before Putting It On Network
    ... hotfixes that it can get. ... and choose the various updates, patches, hotfixes, etc., to be able to ... harden my new server before I put it on the network. ...
    (microsoft.public.win2000.security)