Recent content by Ann Simmons

Thanks so much. You assisted me a great deal. Be blessed. I learned something new from you. Thanks once again.

You are not mere mortals. You also helped in one way or another. I appreciate it so much. Be blessed.

I wanted a hint and I got it from @GPGeorge actually I had 3 related tables tblStudents, tblSubjects and tbltermsubjects. In tbltermsubjects that is where there was numeric values mark to be specific. When I used @GPGeorge idea and applied it in tbltermsubjects it worked perfectly. I thank this...

I like this forum. I have learned alot. Be blessed everyone

Thanks everyone

Two Records

I have this table Subjects In this table:- Description In this description:- I have Chemistry Physics Question- how can I formulate a query to add the two Subjects to give a TOTAL. TOTAL = (CHEMISTRY+ PHYSICS)

I like this. I have learned alot. You people are very experienced when it comes to databases. Question:- what if you want to rank Students according to:- 1. Marks 2. StudentID 3. Years 4. Term 5. Grade 6. Stream 7. Examinationtype. I get data type mismatch in after creating a function and...

N RECORDS should come from the field lets call it FIELD A. How do you go about it?

Thanks

Hello everyone. How do you select TOP N RECORDS FROM CROSSTAB QUERY? I will be grateful for your assistance. Thanks.