Search results

  1. J

    Group By in a Median Query

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

    Group By in a Median Query

    anyone else has any suggestions?
  3. J

    Group By in a Median Query

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

    Group By in a Median Query

    Anyone? Hello?
  5. J

    Group By in a Median Query

    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...
Back
Top Bottom