order by

  1. G

    INDEX and MATCH formula

    I need help creating a formula to look up values in order in the rank column in the table on the right, and pullover the Group A country onto the table to the left. The idea is that I hide the table to the right that is calculating scores based on another area in my spreadsheet, and I will use...
  2. R

    Display contents on form by sort of dropdown list

    Hi All, Quick question (probably very basic... so apologies in advance) .... I have an access form used by reception, it registers: - caller name - caller phone - who they want to speak to (dropdown list of names) - brief message of content of call If my name is one of the ones on the drop...
  3. J

    Ordering file read in via ODBC

    Hi, An awkward problem here I suspect! Creating a pivot from a text file, read in via ODBC. This works fine, so naturally they want to change it :rolleyes: Currently: Set objMyPivotCache = ActiveWorkbook.PivotCaches.Add(SourceType:=xlExternal) With objMyPivotCache .Connection =...
  4. P

    Need help with ORDER BY SQL syntax

    Hello, I have built a crosstab query to calculate a sum for a specified date. ACCESS automatically populates the query alphabetically by the "CourtTimeSaved" column, however, I want a different ORDER BY list. How may I do that? TRANSFORM Count([Court Time Saved].ID) AS CountOfID SELECT...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top