Recent content by johnottawa

Thanks for your reply, but no. Both table and field name are spelt correctly. Any other suggestions?

anyone else has any suggestions?

Thanks, but no. It is spelt correctly. I used "table", "number" and "name" just as examples.

Anyone? Hello?

I get "Run-time error 3131 Syntax error in FROM clause. Any idea why? This is how I call the function: SELECT [table].[name], [table].number, MedianF("table","number",[name]) AS median FROM [table];I also created the module as "option compare database" and then tried "option explicit" Neither...