MS Access - query to read until first and second occurrence of a new line characters

Watch this example on YouTube:


First Occurrence: Left([Field1],InStr(1,[Field1],Chr(13)))

Second Occurrence: Left([Field1],InStr(InStr(1,[Field1],Chr(13))+1,[Field1],Chr(13)))