I use the following code to pull just the first line of a three line field in a query. Left([Bill To],InStr([Bill To],Chr(10)))
this works great , but I have a few accounts that only have one line and when I run this query it will leave all the customers with one line in the field blank and if there is three lines than it works great by just showing the first line. I need it to show the first line if there is three lines but also if there is just one line. Thank you Angie