Can You Call a Function in a Query?

[Debased]

This may be a dumb question but I ain't proud: Can you calll a function from a module in a calculated field of a query? I have found a wonderful sample on this site that calculated business days but it is used in a form and I want the same function but in a calculated filed in a query. Is it possible to do this?
If so, how?
thank you!!

 

[WayneRyan]

debased,

Sure ...

http://www.access-programmers.co.uk/forums/showthread.php?t=68987

Wayne

 

[The_Doc_Man]

Yes. The only requirements are that the function must be declared as public and defined in a general module (rather than in a class-module for a form), and it must return a value usable by the query.

 

[AndyDa]

hey wayne

i've got a similar problem, is there any chance you can convert the zips in the thread to Access 97?

cheers

andy