Search results

  1. A

    Calculated fields from normalization tables

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

    Calculated fields from normalization tables

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

    Calculated fields from normalization tables

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

    Calculated fields from normalization tables

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

    Calculated fields from normalization tables

    Thanks everyone
  6. A

    Calculated fields from normalization tables

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

    TIP How to show rank order in a query

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

    SELECT TOP N RECORDS FROM CROSSTAB QUERY

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

    SELECT TOP N RECORDS FROM CROSSTAB QUERY

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