The report would pull all records from the cross tab on any Job Order that is say greater than 90%
You should research basing reports on cross tab queries because if there's a chance that the number of columns returned by this query could change, simply creating a report from a crosstab can cause that report opening to fail (when there's more report controls than there are fields returned by the query).
As for not needing any vba, not sure how you'd send email without it - unless maybe you use macros (which I would not). For this you would search "send email from Access" or something similar. What you want is doable, but it involves a bit of work.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.