Sort by Column Instead of Field

[kcmark]

I am working with a continuous form and am adding a sort feature to the column headings. There are 5 columns in my form and I want the user to be able to click on the header and sort the data by that field. I can do this when the column contains a field that pulls directly from the query, but I have a couple of columns that are calculations and cannot get the sort to work for these columns. I am using the following code with the OnClick event (which works great for non-calculation fields):

Me.OrderBy = "[Trans_Date]"
Me.OrderByOn = True

Any ideas on how I can sort by the calculation fields?

 

[cgarts]

Can you move the calculation into the source query for your form, than treat it the same as your other columns?

C

 

[kcmark]

Thanks! It worked like a charm - why didn't I think of that?