I have a table that pulls notes from a software we use. Only problem is each entered line in the software comes out on a separate line in the table in access. I need to pull out only the disposition from the table. Not sure how to do that because the disposition could be on multiple lines. I need to pull anything that starts with Disposition and the subsequent lines following that since disposition is always at the end and usually is on multiple lines. Everything before disposition needs to be filtered out. I attached two images that might help you understand what I am looking for a little better. Any help would be much appreciated!
SELECT OH.OH_NUMBER, PK1_NL.NL_LINE, PK1_NL.NL_LINE_NO
FROM OH INNER JOIN PK1_NL ON OH.OH_NMSEQNUM = PK1_NL.NL_NMSEQNUM;