Functions not working

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.
>
In answer to an earlier post, eng...@ridesoft.com suggested that I look at
my references - some are missing. I do not understand this - what are
references and where do look for them?
>
Can any one help please?
>
Peter

In answer to an earlier post, engles@ridesoft.com suggested that I look at
my references - some are missing. I do not understand this - what are
references and where do look for them?