access database data manipulation

Article View: borland.public.cppbuilder.database.ado

Article #3927

Back to borland.public.cppbuilder.database.ado Previous Next

#3927

From: Margaret
Date: Wed, 15 May 2002 18:03

14 lines
1511 bytes

I am new to the more advanced features of access.  I am working on the
97 system and need to know how I can in a report if data is not
available in one field or that field data is set equal to one thing
can I get data from another field inserted into that field.

The problem is that I have two sets of addresses--mailing and home. 
On my mailing label report I have to use the Mailing Address field to
catch all PO Box addresses that are available.  I want to know how I
can get the report to insert the Home Address field entry if the
Mailing Address field is blank or contains something like 'n/a'.

Please help me.  I have not been able to find this answer elsewhere.

Thank you.

Technical Details

Message-ID: <f7bf5080.0205151003.43d7e453@posting.google.com>

Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,37d15807a13d3f26,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-05-15 11:03:59 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail
From: Mstevens@govoepp.state.sc.us (Margaret)
Newsgroups: borland.public.cppbuilder.database.ado
Subject: access database data manipulation
Date: 15 May 2002 11:03:58 -0700
Organization: http://groups.google.com/
Lines: 14
Message-ID: <f7bf5080.0205151003.43d7e453@posting.google.com>
NNTP-Posting-Host: 167.7.127.186
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1021485839 23745 127.0.0.1 (15 May 2002 18:03:59 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 15 May 2002 18:03:59 GMT