Prob running query based on Date function

[j0se]

I'm looking for some help on this one:

I have a macro based on a query that returns all the entries created today:

[Date_Created]=Date()

This works fine on my machine (Win2k , svp 6, Office 2000, svp 2) but doesn't run on the machine I needed it to run on! (Win2k, office 2000 - unknown svp versions)

There are no missing references (that would 'break' the Date function) and the query returns nothing.

I'm at a loss. Thanks to anybody who can shed some light on this one for me

 

[Rich]

it's a certainty that it's a missing reference problem.

 

[j0se]

cheers

Nice one - at least that focuses me on the prob!

Thanks a lot!!