Trying to order my column headings

Tech-Archive recommends: Fix windows errors by optimizing your registry

I am using the query below as the simplest thing I could think of to
get a list of dates for my
front-end application. It results in a header row of dates (which is
what I use), along with a single row that includes the default measure
for each date (which I ignore).

So this is ok, but the dates are in ascending order, and what I would
really like is to have them in descending order, so that the newest
date comes first. I've tried some ORDER statements, but haven't found
one that has the desired effect.

SELECT { [Date Dim].[Week End Date].ALLMEMBERS
} ON COLUMNS FROM myCube

.

Relevant Pages

  • Re: Can I do this with the LARGE function?
    ... your data table, with header row included (Insert.Name.Define from menu, ... point the left upper cell for returned query table. ... In another sheet in my workbook, I want to have a similar> table, but sorted by descending values that are located in column D. With> the large function, I can get the value from one sheet to another, but I> would like to know how to get the rest of the row of data to come with it> into the new worksheet. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Append import data to existing record
    ... Created a field [PlanYear] that gets populated with the 4 digit year from ... Created the first query (was so excited that it ... SELECT Forms!fSARMain!fSAR!PlanNum AS PlanNum, Forms!fSARMain!fSAR!PlanYear ... Just wanted to verify one item: I do have a header row. ...
    (microsoft.public.access.externaldata)
  • Re: Append import data to existing record
    ... Just wanted to verify one item: I do have a header row. ... >> First, open a new query. ... >> Forms!MainForm!SubformControl!TheYear AS TheYear, ... >> the subform is bound and qryFromTxt. ...
    (microsoft.public.access.externaldata)
  • Re: Exporting Access Table to Excel spread sheet in code still shows h
    ... they always include a header row with the field names. ... you can write and execute SQL queries that address particular ... Append query inserting data starting at A1: ... I want it to poulate numbers in Cell A in the spread sheet. ...
    (microsoft.public.access.externaldata)
  • Re: Microsoft XL Spreadsheet
    ... I run a query and make an Excel spreadsheet. ... >Clear the header row: ...
    (microsoft.public.access.queries)