Access Make Table Query

  • Thread starter Thread starter Jayne
  • Start date Start date
J

Jayne

I have a table that contains the following data. order
number, narrative, line number I need to use a make table
query to create a table that if the line number is 1 put
the narrative in one data field if it is 2 put the data in
a seperate field. Any one any idea's
 
Jayne,

When you create your make table query, create 2 new
fields to hold your narratives.

Newfld1:iif([line number] = 1,[narrative],"")
Newfld2:iif([line number] = 2,[narrative],"")
 
Back
Top