Search results

  1. A

    Using a query as a function?

    Tb1 is like Grade TimeDiff P_neg 1 200 0.1 1 300 0.2 1 500 0.3 2 200 0.2 2 300 0.4 2 500 0.7 3 200 0.3 3 300...
  2. A

    Using a query as a function?

    Hi, Thank you for your reply, but I don't understand (1) why do I make a copy of Q1 and (2) how to remove the two manual parameters in Q1 function. e.g. inside Q1's function, I have formula like: Result = a+b. And, some a and b are in the criteria, such as pick up c if a<1. Even if I can move...
  3. A

    Using a query as a function?

    Hi, Can any one help of this please? I have a fairly complex query (Q1) which outputs a calculated value from a table. To make it easier to understand, the calculation estimates the middle point between two dots in a scatter plot. To run this query, it asks for a 2 manual input values, say a...
  4. A

    Ranking

    Thank you for your reply. This is one of those situations that I have been thinking about this 'problem' for a whole day, then I gave up and decided to post it on a forum for some help, got no reply for a few hours, then I rolled up my sleve and finally solved it on Friday night. My solution...
  5. A

    Ranking

    I searched the forum, but can't found any which is similar. I got this data set (TB1): DeptA Date1 Staff1 DeptA Date1 Staff2 DeptA Date2 Staff3 DeptA Date3 Staff4 DeptA Date3 Staff5 DeptB Date1 Staff6 DeptB Date1 Staff7 DeptB Date2 Staff8 *Note: 1. Date...
Top Bottom