On Mar 23, 8:39 am, "Peter B" <kealtiess...@f2s.comwrote:
Quote:
I have MS Access 2000. I have recently installed it on a new computer and
transferred my mbd files across. These work OK, including those using SQL
Aggregate funtions. However if I set up a new database, I find that some
of these functions do not work. For instance, I get #Error messages when
trying to use count([fieldname]) or Date(). Sum works OK. As far as I can
see all relevant parts of Access and MS office seem to be installed.
>
I have run repair and installed the latest MS Office service packs (to SP3),
but the problem remains.
>
Can any one help please?
>
Peter
Look at your references. Some are missing.
