If Statement Query in Access 97

Article View: aus.computers.tex

Article #360

#360

From: michaelchant
Date: Tue, 09 Sep 1997 00:00

12 lines
1269 bytes

I have a database with seperate street address and postal address fields.
When I wish to produce address labels, how do I write a query that will
choose the postal field if there is an address there, but choose the
street address field if the postal is empty?
I know I should be using an If Statement, but I am not sure where I
should be writing it, or exactly how it should be constructed.
Thanks for any help you can give.
MICHAEL CHANT

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Technical Details

Message-ID: <873802498.371@dejanews.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10b0c4,e22d1764e319fa40,start
X-Google-Attributes: gid10b0c4,public
From: michaelchant@pobox.com.au
Subject: If Statement Query in Access 97
Date: 1997/09/09
Message-ID: <873802498.371@dejanews.com>
X-Deja-AN: 270961733
X-Originating-IP-Addr: 203.23.145.162 (proxy.camtech.net.au) proxy [1.0 proxy.camtech.net.au:88 (Squid/1.1.10)] for client [unknown]
X-Authenticated-Sender: michaelchant@pobox.com.au
Reply-To: michaelchant@pobox.com.au
X-Http-User-Agent: Mozilla/3.01 (Win95; I)
Organization: Deja News Posting Service
X-Article-Creation-Date: Tue Sep 09 10:54:58 1997 GMT
Newsgroups: aus.computers.tex