Search results

Hi, I have a student table with stdno,stdname,stdmajor,stdgpa etc as columns. I need to create a Sql statement to find : For each major ----the stdno,name and gpa of student with highest gpa. The following stmt gives error,pls help SELECT StdMajor,StdNo,StdFirstName,StdLastName,StdGPA WHERE...

Hi, I noticed a problem in my current form say customer When i add education_ details through another form, it opens another window and i am able to add/save the details. Now on closing the form and returning to the original window the information is not refreshed ie it does not display the...

Hi, I am done with the form in access 2003 and now only need to make it look good.I have two questions -- 1. Is there a way to remove the extra blank record in form which is to insert new records. 2. How to change the background color of the command button ---Rosh

Hi, In my university database i have a member,faculty ,student and staff table. I have a new member form and depending on which member type (attribute)i want to display the corresponding faculty, student or staff table.All other subform should be hidden. Could you suggest some workaround --Rosh

Hi, I am new to access, i have a insurance database with customer table and policy table.I have created a form which displays customer as well as existing policy info. I want to have 'add policy' so that it open policy form to insert new policy My problem is that when i add policy subform it...

Hi, I need to create a single form for insurance db(Access 2003)with customer info and insurance policy info. I have both customer(primary key=customer id)and policy table (primary key=policy id)in the db. Can somebody please help me in creating the form as one customer can have multiple...