Recent content by hbl1992

  1. H

    Transforming Multiple Rows into Single Row in a New Table based on column value in original table

    The final result i need is a pdf of the Delivery Challan with the details of upto 6 lots (i intend to do that thru msword mail merge after all the data is in a single row)
  2. H

    Transforming Multiple Rows into Single Row in a New Table based on column value in original table

    DLV_LOTLIST DLV_LOTLIST ID DELIVERY_CHALLAN_NUM AUCTION_NUM LOT1 LOT1_NAME L1_QTY L1_BAGS L1_SL L1_AMT L1_LTNUM DC_SLNO_1 DC_BROKER1 DC_ROW_NUM1 DC_SLNO_2 DC_BROKER2 DC_ROW_NUM2 1 12 1 GOLD BP 216 8 1 TO 8 54000 1 141 ab 1 3 13 3 GOLD OF 54 2 11 TO 12 13500 3 141 ab 2 143 pe...
  3. H

    hi from hbl

    hello. i'm fairly new to access and databases, and i hope to exchange wisdom here. i'll leave with a quote of mine - "Give me the database, and I'll give you the audited reality."
Top Bottom