Are you saying that all of that information, including Carriage Return/Line
Feeds, is being stored in a single field? If there's a chance to change your
design so that the address fields are properly normalized, do it!
To get everything up to the first Carriage Return/Line Feed, try
Left([AddressField], InStr([AddressField], Chr(13) & Chr(10)) - 1)
(change AddressField to the appropriate name)
If there's a chance that some of the fields don't have the Carriage
Return/Line Field combo in them, try
IIf(InStr([AddressField], Chr(13) & Chr(10)) = 0, [AddressField],
Left([AddressField], InStr([AddressField], Chr(13) & Chr(10)) - 1))
(all on one line)
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Rastamon" <Ra*********@gmail.com> wrote in message
news:11*********************@l41g2000cwc.googlegro ups.com...
I am writing a query in Access2000 just with entries from one table.
One of my entries is Cust, for the Customer and the table is in the
data type of a memo with the customer's info set up like this:
Name
address
town
phone #
How can I set the criteria so that the query only comes back with the
first line? Thank you.