If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to sort Sort with selection
Hello;
I want to add a menu a form with different sort by options, what would be the best way to do this? Example: Field choices: Date, Name, Address, Phone, zip 1. Date 2. Name 3. Addy 4. Phone 5. Zip or 1. Zip 2. Name 3. Addy and so on? Thank you. Lou |
#2
|
|||
|
|||
How to sort Sort with selection
UNTESTED ---
Create a separate query for each different sort add an output field like --- NameADDRsort: 1 and ADDRNameSort: 2 Use criteria -- [Forms]![YourForm]![Option] Then use a UNION query to pull the queries together. You will get data only from one query into the union query. "LOU" wrote: Hello; I want to add a menu a form with different sort by options, what would be the best way to do this? Example: Field choices: Date, Name, Address, Phone, zip 1. Date 2. Name 3. Addy 4. Phone 5. Zip or 1. Zip 2. Name 3. Addy and so on? Thank you. Lou |
Thread Tools | |
Display Modes | |
|
|