Search results

Pbaildy, Please let me know the step you take to connect your MDB/MDE to SQL Server? Thanks

Please how can i use a procedure to create a query, then append the content of the query to a table (am using MS Access Project)? i did it in Microsoft acess database but now i need it on Microsoft access Project beacuase am transfering to SQL server. Thanks

Please could any one help me out i have a Nokia 6630 and i want to download a full version of the Holy Bible on it i dont know how to go about it or what to do or even where to get a file that contains the bible from. Please your assistance will be highly apptreciated i need to have the bible...

Could any one tell me how to change the ranking of a field from 1,2,3,4,5,6,....1000 to 1st,2nd,3rd,4th.5th.6th........1000th. Nested if could only give upto 15, and another method that is i used worked but made the query to run too slow. tHANKS

Position, Automayic Solved Thanks Pat Hartman, The Expression worked perfectcly well, i was even able to do the two position at once by using;POisition in Class:(select Count (*) from Table where [Class]=[Table1].[Class] And [Subject] = [Table1].[Subject] And [Score]> [Table1].[Score]) +1...

Thanks i think this should help i will try it ans see then get back to you on how it went. Regards

Please Could any one help out, i have this Database am building for students in a school, The attached WORLD file respresnt a query in the database. The Position in class and Position in level is suppose to grade the student automatically i.e 1st, 2nd, 3rd, 4th, 5th e.t.c. according to the score...

Thanks Colinsessex it worked perfectly . Please check the mail i sent to you

How can i write an expression in a query field that will return the following text; "A","B","C","P" and "F" Base on another field when the values of that field are <=44.44, between 44.45 and 54.44, Between 54.45 and 64.44, Between 64.45 and 74.44 and above 74.45 respectively?