smun04 0 Newbie Poster

Hi,
I have a reportviewer report with an expression in the one field as follows:

IIf([Number of A Levels]>3,(([UCAS Points]/3)*([Number of A Levels]-(1-(1/[Number of A Levels]))))/[Number of A Levels],[UCAS Points]/[Number of A Levels]) AS [Weighted Average]

I need to use the results in the [Weighted Average] to sort the output.

I use table adapters and datasets

Any help will be appreciated.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.