Posted by lemes_m@yahoo.com on 01/31/06 23:10

Thanks for your response.

First, I have to notice that I use MS Access 2003 as Front-End.

I was affraid that passing date is only way because I constructed other
stored procedures to use view to get some data. In this view I used <=
{ fn NOW() } to limit results and after that I joined all other stored
procedures to this view.

Now I got two problems: I tried to create function which uses @SomeDate
parameter to limit results but I can't get it work.

Another problem is how to pass @SomeDate value when I execute stored
procedure which is joined with this function...

Regards,

[Back to original message]