kasper

hi all ,It is a query that do some calculations.the user wants to truncate the final number as follows:if it is 1.3, 2.4 , 5.25 then it should be truncated to 1.5 , 2.5 , 2.5 and if it is 1.6 , 2.63 , 1.85 it should be truncated to 2 , 3 , 2is this possible using SQL ??

Thank you for the link

i thought a lot about this problem but no hope , me is an aerospace engineering student not a professional developer. if possible , it is better that you give me a link and then i study my lesson.i am not a teacher , but i mentioned this in my question to let the reader understand the questoin more fast.thank you again,if you need anything in Aerospace --> me is in service.

hi all,It is a school program to give a number for each student accordig to names sort.for example : Goerge, Sanco, Wiliam and Hanz will be : Goerge -->1Hanz -->2Sanco -->3Wiliam -->4So, i want to view and store these numbers (1,2,3 and 4) in a column called Student_Order. what is the SQL satament ??suppose that this SQL is for Microsoft Access

Yes , you are right. i have a column with thier names called Name and another column called Birthday

i have a table of 1 column , the datatype of this column is Date/Time

hi all ,i am making a program with database , and i need a SQL satatement to:Calculate the age of persons in years , months and daysthe age is betwwn the birthdays and 5/12/2006for example : Goerge age is 30 years, 3 months and 24 days