dbabaracus
New member
- Local time
- Today, 01:57
- Joined
- Jul 26, 2017
- Messages
- 4
I'm building out a database to handle submissions for an art show. Users submit information for up to 20 pieces of art. The export from the webform is a .csv that resembles this:
UserID, UserName, Title1, Height1, Width1, Price1, Title2, Height2, Width2, Price2,[...], Title20, Height20, Width20, Price20
What I'd like to do is paste that data into a table and somehow translate it into separate rows/records for each piece.
Like so:
User001, Billy Billson, Untitled #1, 12, 10, $5, Untitled #2, 23, 15, $10...
Translated to:
User001, Billy Billson, Untitled #1, 12, 10, $5
User001, Billy Billson, Untitled #2, 23, 15, $10
I've seen solutions for similar problems where you use a query with unlinked tables and have each field as a series of nested IIf functions. But I don't think Access (or I) can handle 20 nested IIfs. Is there a good way to go about this?
The actual fields for each piece are:
Title
Medium
Length (number)
Length Unit ("FT" or "IN)
Height
Height Unit
Width
Width Unit
Price
UserID, UserName, Title1, Height1, Width1, Price1, Title2, Height2, Width2, Price2,[...], Title20, Height20, Width20, Price20
What I'd like to do is paste that data into a table and somehow translate it into separate rows/records for each piece.
Like so:
User001, Billy Billson, Untitled #1, 12, 10, $5, Untitled #2, 23, 15, $10...
Translated to:
User001, Billy Billson, Untitled #1, 12, 10, $5
User001, Billy Billson, Untitled #2, 23, 15, $10
I've seen solutions for similar problems where you use a query with unlinked tables and have each field as a series of nested IIf functions. But I don't think Access (or I) can handle 20 nested IIfs. Is there a good way to go about this?
The actual fields for each piece are:
Title
Medium
Length (number)
Length Unit ("FT" or "IN)
Height
Height Unit
Width
Width Unit
Price