Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by NadCan

  1. NadCan

    Field Un-Concatenate in MS Access (SQL)

    Hi Guys, I need your help. I have a table (in MS Access) with a couple of hundred thousand records in a field 'Address' as below: Address ---------------------------- 111 - 2 AVE RD LETHBRIDGE AB 123 WILSON DR WHITEHORSE YT 333 SIMPSON AVE MOOSE JAW SK I need to split this field as follow...
  2. NadCan

    How to create duplicate rows in Access or Excel ?

    yep Golom, that's excatly what i needed ... Thanks guys !
  3. NadCan

    How to create duplicate rows in Access or Excel ?

    Great pwise, it worked .. ! Many Thanks, nad.
  4. NadCan

    How to create duplicate rows in Access or Excel ?

    Hi Golom, It worked GREAT ... !!! ... Many thanks !!! One last thing, since i'd be getting a same data (mytable) every week with different [Label Quantity] figures. For instance i'll receive a revised table next week, like below: ID Item Name Item Code Print Quantity Label Quantity 1 Global...
  5. NadCan

    How to create duplicate rows in Access or Excel ?

    Hi, I have a table with the following fields: ID Item Name Item Code Print Quantity Label Quantity 1 Global Equity 01-03-060 677 30 2 Select Growth 01-05-026 823 40 I need to generate 30 duplicate lines for ID:1 and 40 duplicate lines for ID:2, automatically. Please advise how can i do it in...
See more

Part and Inventory Search

Back
Top