Search results

  1. Y

    Query and Sub Query Help Please

    It looks like you've joined on the wrong column. Both the Query text and the QBE have qrysub_QtyDelivered.TransHeaderID = tblTransLines.tlOrderHeaderFK but it should be qrysub_QtyDelivered.TransHeaderID = tblTransLines.tlTransHeaderFK.
  2. Y

    Row Number

    If your table is Table1 with the column to be sorted DATA_COL _number, then if you join it to itself You can have a query Select Table1.DATA_COL _number, count(*) as rank from Table1, Table1 as T1 where T1.DATA_COL _number>=Table1.DATA_COL _number Group by Table1.DATA_COL _number order by...
  3. Y

    Print labels from query with column [TEXT] and [AMOUNT]

    I tend to go the dynamic route. I have a table called Integers that has one column Num with the values 0,1,2,3,4,5,6,7,8,9. I then have a query called Numbers that generates all the numbers up to 10,000. It has the Integers table added 4 times with no joins. SELECT...
  4. Y

    Hello

    Hello All I've been a lurker on this forum for a long while, and its now time for me to contribute where I can. Yev
Top Bottom