Need to sort by an Added Field but don't see it available

[Dave14867]

Hello all,



I created a report and that is working fine, I then added a field (txtStatus) that compares two other fields and inserts either "OK" or "Order". I want to now sort the report by the added field "txtStatus" but when I try to "Sort by the Select Field", the "txtStatus" doesn't appear.

What am I missing?

Thanks
Dave

[pbaldy]

Moving that expression to the report's source query is probably easiest. Then it's a field you can sort on.

[Dave14867]

pbaldy,

I thought about that and did that, but it still doesn't appear.

Thanks
Dave

[pbaldy]

Really? Make sure the Show box is checked in design view. Can you attach the db here?

[Dave14867]

pbaldy,

The file is attached, Open the "Forecast Build Requirements" form, select or type in "m22281" in the combo box, select "5" for the build quantity and the report will open.

I want to sort on the "Status" field so that parts that are designated as "Order" appear at the top of the report.

Daves MRP- 9-10-18 - In Use.zip

Thanks

Dave

[pbaldy]

I don't see the calculated field in the query? I added this to the query:

SortField: IIf([Forms]![Forecast Build Requirements]![txtBuildQty]*[Qty]<[QtyOnHand],"OK","Order")

and sorted on that.

[Dave14867]

pbaldy,

I was using the Status:Comments Field from tblPartMain, in the "Attempt at Query-2 Working?" query, then added the "=IIf([BuildQty]<[QtyOnHand],"OK","Order")" as the control source to the text box in the report.

Where did you add the Sort Field?

Thanks

Dave

[pbaldy]

To the query. That makes it a field you can add in sorting and grouping.