Sort Values in a report

[vipersmind]

Hello good people of the forum
In the attached db example2 the report "report_log2" is not sorting properly for me.
Ideally it would be sorted by the first field depth "from" and then by the assays "from" field.
The problem is that not all of the assays "from" fields have values. The ones without values tend to be thrown to either the bottom or the top of the report.
The idea is that the assay "from" intervals should fit in the range of the first depth "from" field. Confused?

This is doing my head in and has been for a while....

The report is normally run from a query but for ease of attaching I have cut it down...........it may need more explaining...ask away!

 

[vipersmind]

sorted........brain was shutdown

I have sorted this myself............. must have temporarily disconnected from my brain.

Just made a new field and populated with

IIf(IsNull([Depth_From]),[Assay From],[Depth_From])

then sorted by this field

2easy