Search results

  1. C

    empty fields causing problems

    The query below works, when there are no empty fields in the column Total. If there are empty fields is not working. query = select INT( Total / 10 ), COUNT(*) from POINT where Member_Title = 'Mr' GROUP BY INT( Total / 10 ) ORDER BY INT( Total/ 10 ) Can...
  2. C

    login table?

    hi... i have a table member and a table quest i want to set usernames and passwords for the members and quests. what is better? to have a field called password and another field called username in both tables OR have a table called memberlog with fields memberid, password and username...
  3. C

    validation rule

    Hi... I am trying to write a validation rule in design view of a table that will allow a fixed 8 digit number in the field called ID. Because i am a newbie can anyone please tell me how can i do it...? Thanks in advance.
  4. C

    median

    Hi... i am trying to display the median using a query. Its pretty easy to find the average, max and min but i dont have any idea on how to find the median... e.g in order to find the maximum i wrote: query = "SELECT max(TotalMark) as max from MARK" _ & " WHERE Title = '" & title &...
  5. C

    validation rule

    I am a newbie, i just started useing access 2000. i have a table Sport and a table SportPoints. In the table Sport there is a field called MaxPointsAvailable: e.g. for tennis the MaxPointsAvailable is 30 for squash the MaxPointsAvailable is 40 In the table SportPoints i have a field...
Back
Top Bottom