Search results

I need to create a query where in the end, I will have four rows of data based on based on two combinations of WaterSourceType and Crop. I need the query to bring back the results of the average Top N (lets say Top 10%) for each combination. I have tried this every which way and I can't seem...

I am trying to alter this parameter to bring back all records if either beginningsalesrange or ending salesrange is left blank. I can't quite get it right. Thanks Between [forms]![frmState]![BeginningSalesRange] And [Forms]![frmState]![EndingSalesRange]

I am working on a Totals Query. The query has a lot of calculations in it. I have one expression for Salary as a % of Gross Revenue. My issue is that I don't have salary information for each row (account). I only want to calculate the totals of those accounts with salary information without...