aldeb
02-22-2007, 05:38 AM
I have a crosstab query of which I cannot sort a Totals column by descending order. Is there any way to sort a certain column automatically after the query runs and is in Datasheet view?
|
View Full Version : Sort column automatically in Datasheet view aldeb 02-22-2007, 05:38 AM I have a crosstab query of which I cannot sort a Totals column by descending order. Is there any way to sort a certain column automatically after the query runs and is in Datasheet view? namliam 02-22-2007, 05:47 AM A crosstab query is not sortable... ever... That is untill you make a new query to query the crosstab... aldeb 02-22-2007, 06:15 AM I know that you cannot sort a crosstab that is why I asked if you can automatically sort a column in Datasheetview? I take it that you cannot! namliam 02-22-2007, 06:18 AM You can... but in a second query... NEVER in a crosstab... aldeb 02-22-2007, 06:30 AM Thanks for your answer. I will just create another query. I appreciate your help. |