Recent content by Christos

thanks thanks for the help and the explanation

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...

yes but what is troubling me... are the relationships. if i do it 1 table Fields: UserID UserName Password UserType: Value would be either G (for guest) or M (for member) Disabled: Y/N what will be the relationship between the table member and the new table called e.g. login i think...

i am asking because i did it using the second way and i am afraid that is not correct... thanks for the help...

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...

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.

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 &...

thanks I am sorry if i sounded rude... I do appreciate the help. Christos

ok... thanks for the help and i am not doing any project!

Thanks thanks at least now i know that this cannot be done. I asked because when i am writing e.g. <= 100 in the field *validation rule* is not letting me type a number more than 100 and i was wondering if i could write a code for that. Thanks for the help

yes i know but i know... but just for myself...To prevent me inserting a point bigger than the max point when i am working directly with tables. Is it possible to tell me how can i do it.? Thanks for the help.

yes but No i dont have a form... but when you open the table in design view and you click on data type, down to field properties there is a field called validation rule. you can write the validation rule there. Am i right....? Thanks for the help

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...