Recent content by aymarhoon

  1. A

    Where In operator

    Thanks for your help.. I did not notice that you already mensioned so in you previous post Sent from my ANE-LX1 using Tapatalk
  2. A

    Where In operator

    How can I chart the result of the crosstab query? I mean from the Form the command button opens a report showing a chart instead of the crosstab query.. Sent from my ANE-LX1 using Tapatalk
  3. A

    Where In operator

    this is really awesome.. Thank you a million times for your help.. You really made things look simple. Thanks again...
  4. A

    Where In operator

    Is it possible to make a function to have A-F then we add to it the result coming from a select query?
  5. A

    Where In operator

    There are 7 Sent from my ANE-LX1 using Tapatalk
  6. A

    Where In operator

    I want to use the result of query to generate a chart but I don't want fixed Headings for (W, DIS, WF, etc) after the F to appear on the xaxis. For instance, the xaxis will show A - F followed by W only or A - F followed by W, DIS I thought it might be possible to write a select query to get...
  7. A

    Where In operator

    Thanks MajP I want fixed column from A to F followed by dynamic columns based on returned data.. Dynamic columns may include W, Ab, DIS, WF, etc Sent from my ANE-LX1 using Tapatalk
  8. A

    Where In operator

    Hi guys Is it possible to have specific values and values from a select query in IN*Operator. I mean something like this SELECT tblStudents.*, Grade FROM tblStudents WHERE Grade In ("A","A-","B+","B","B-","C+","C","C-","D+","D","F", SELECT DISTINCT tblStudents AS Grade FROM tblStudents WHERE...
  9. A

    Sum in unbound text box returns #error

    Thank you very much, both solutions worked very well. I have another question... How can I make the incremental change of the spinner button by 0.1 not a whole number? Thanks a million times
  10. A

    Sum in unbound text box returns #error

    Hi everybody Is there a way to sum unbound box. I read several threads and tried their suggested solutions but none of them worked. I attach the database to give you an idea about the problem. Any idea would be greatly appreciated. Thanks
Top Bottom