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!
-
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!
-
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...- NadCan
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
-
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...- NadCan
- Thread
- Replies: 12
- Forum: Microsoft: Access Queries and JET SQL
