Hello.
Is it possibly to sort a query using a calculated variable? Let's say I have a table with the following fields. Name, Number1, Number2. What if I want to display all 'Name' values sorted by Number1 + Number2 (sorted by their sum) or perhaps Number2 / Number1. Is that possible? And how would I do that?
Thanks,
- shazow
Is it possibly to sort a query using a calculated variable? Let's say I have a table with the following fields. Name, Number1, Number2. What if I want to display all 'Name' values sorted by Number1 + Number2 (sorted by their sum) or perhaps Number2 / Number1. Is that possible? And how would I do that?
Thanks,
- shazow