Hi,
I have made several calculations using expression builder in one of my forms, and now before i create my report I am trying to use the query wizard or builder to pull out the information which i want from my tables, but when I run the query, the results from the expressions/calculation which I had functioning in the form, the results are not showing up in the query.
The expression which I am talking about currently trying to egt it to show, is one which shows the average of the results of 10 fields combined i.e. I have 10 body condition scores of animals which this calculation finds the average of them combined.
Also do I really need to always use a query builder before forming a report if I am taking a range of things from tabels or different tables combined?
I am enw to this, so any help at all would be greatly appreciated.
Joce
I have made several calculations using expression builder in one of my forms, and now before i create my report I am trying to use the query wizard or builder to pull out the information which i want from my tables, but when I run the query, the results from the expressions/calculation which I had functioning in the form, the results are not showing up in the query.
The expression which I am talking about currently trying to egt it to show, is one which shows the average of the results of 10 fields combined i.e. I have 10 body condition scores of animals which this calculation finds the average of them combined.
Also do I really need to always use a query builder before forming a report if I am taking a range of things from tabels or different tables combined?
I am enw to this, so any help at all would be greatly appreciated.
Joce
