Sorting form by unbound textbox 1

[bill1one]

I have a report that displays 8 different values from my table. I then have an unbound textbox that shows the sum of those 8 values. I am trying to sort the report in descending order based on the sum. I tried using the property “Order by” but that does not seem to work. Is there a way to sort of report, based on the value in an unbound txtbox?

 

[jebry]

Hi!

I don't think you can. But, you can create a query and calculate the sum there. Then base your report on the query and you will be able to sort by the sum.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[bill1one]

How do you calculate sums in queries. I want to total the values in the fields [Week 1], [Week 2], ...[Week 8] in the table tblName.

Thanks.

 

[jebry]

Hi!

Select *, [Week1] + [Week2] + [Week3] + etc As SumOfWeeks
From tblName

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[bill1one]

Thanks tons. That worked beautifully!