Sorting on a calculated field

G

Guest

I have a text box on a form where the control source is a calculated value.
The users want to sort or filter on this field, but those options are grey-ed
out. Is there a way to do that?
 
G

Guest

Croydon,

Create the calculated field in a query, base the form on the query, and bind
a textbox to the field.

Hope that helps.

Sprinks
 
G

Guest

That works. Thanks very much.
--
Croydon


Sprinks said:
Croydon,

Create the calculated field in a query, base the form on the query, and bind
a textbox to the field.

Hope that helps.

Sprinks
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem sorting and filtering on a calculated field 4
Access MSACCESS - Sorting report based on field calculated in the report 0
Need help on how to pass calculated field from a form to another form 0
Saving a calculated field 8
Validate the number of checkboxes that can be true 0
Using DSUM to get running total on a filtered form 0
Values calculated in a Form entered in the Table? 6
Calculated Field in Form 6

Top