Error 3075 Function Isn't Available

[rlf1957]

I have built an aging report (C,30,60,90 etc) using a version copied from the Order Entry db template. The Order Entry Db version works just fine but the version I have brought into my db and modified is giving me fits with the following error.
***Function isn't available in expressions in query expression - 'Sum(IIf(Date()-[InvoiceDate]<31,[LineTotal],0))'

Using Access97 in XPHome.

Curiously, this report works just fine on my laptop at work, which has both Access97 and Access2000 installed.

Can anyone give this novice some guidance as to the solution.
Thanks

 

[KenReay]

Hi

This is almost certainly a missing refrence to an object library.

Open any code module in design view, seelct tolls \ references from the menu, look at the list of selected object libaries to see if any are marked MISSING (my money is on the Microsoft office library), if there are any MISSING, note the name, and deselect them, then look down the list and reselect them (version number will probably be slightly different but that will not matter)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[rlf1957]

Thanks for the info - that seemed to do the trick. I think it was the Jet Expressions .....
Anyway, the reort works now - thanks very much