Use a Module in an SQL query

[Hfnet]

I am finding datediff is not doing what I want in an SQL query in an adp project.

I have a module that I use in forms, and it also works in mdb queries, but not recognised in adp.

I am basically wanting to use module GetDay(datein,dateout) in a stored procedure.

How can I get the stored procedure to use the module?

 

[dhookom]

You can program user-defined functions in SQL Server. Perhaps if you provided your function, someone could give you a solution that might work.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]