Search results

  1. A

    Its me again - SUM Function

    Ok , I have a table called cons. I have a field in cons called NOP I would like to add the numbers together in this field and so used Select SUM(NOP) from Cons This cases an error "datatype mismatch in criteria expression" What is going on ? Adam I have looked at the database and the...
  2. A

    SELECT DISTINCT help...Please

    Ok , I will try and explain this as best I can. I have a database and would like to run a DISTINCT query ( which I can do no problems ) I would also like to count the number of records at the same time. Say for example my database looked like this Name Fruit Adam Apple Carrie...
Back
Top Bottom