Hi Experts,
I have two tables - tblContact and tblOrg
Contact table has only one option of mailing address e.g address,city,po stal code
whereas Org table has two options - one simple address - address,city, postal code
and other one is mailing address which is populated automatically if a check box is checked "Is mailing address same" - mailing address, mailing city, mailing Postal code
I want to generate a mailing list that gets all the addresss of the Contact table and
all the addresses from Org table but with mailing address populated as the first choice and if mailing address is empty then to use the simple address.
I really appreciate any help.
Regards,
Raz
3 2028
have u tried using the Nz() function? if you are populating the list using a query, a simple example would be this:
MailingListAddr ess: Nz(MailingAddre ss, SimpleAddress)
MailingAddress is selected unless it is Null... in which case, SimpleAddress would be selected
Thanks a lot n8kindt
Nz() is a good one that I didn't know about.
I got my problem solved partially though as two tables are related and any entry in the Org table that doesn't have a contact associated with it from Contact table is not shown in the result set.
How I can have all the records from both table?
I am using MS Access 2000 and tblOrg is master table in the relationship.
Thanks for the help.
Raz
Thanks a lot n8kindt
Nz() is a good one that I didn't know about.
I got my problem solved partially though as two tables are related and any entry in the Org table that doesn't have a contact associated with it from Contact table is not shown in the result set.
How I can have all the records from both table?
I am using MS Access 2000 and tblOrg is master table in the relationship.
Thanks for the help.
Raz
have u looked into union queries? i think that might be what u need.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Dave Moore |
last post by:
Hi All,
Is it possible to implement a mailing list using PHP?. I know I could
maintain a list of emails addresses in a db and send mail to them through my
website, but how can I get true mailing list behaviour where emails are sent
to a particular address (like mailinglist@mydomain.com) and then distributed
to all of the email addresses?.
Ta,
Dave
|
by: Brian van den Broek |
last post by:
Hi all,
There have been a few posts over the last month or so expressing a bit
of exasperation with the "rising tide of newbie's". (Or, more
accurately, the rising tide of questions from newbie's not trying to
follow ESR's advice.)
A month or so ago (in a thread found here: http://tinyurl.com/5bj8j), I
suggested that it might help the situation if there were a python.org
wiki page that amounted to a "Welcome to the Python community;...
|
by: Mark V. |
last post by:
Here's what I have and I'm stumped. I have a table that has several
thousand names and addresses. I only want to send to one address in a
household. So what I would like to do is create a new column that runs
a macro or whatever it takes to flag records so they are housholded.
Some records have a Father and son at the same address, so I would
only want to generate a count in my query that gives me one record for
that household, a head of...
|
by: Grim Reaper |
last post by:
I know this is probably an easy question, but I could not find/figure it
out.
Basically, I am printing mailing labels with a "Sorting/Grouping" section
that groups the label types together. Also, I am using a "Report Header" to
show a count of how many total labels that are being printed.
Now, my problem is that without the "Report Header", the spacing is perfect.
But, when I add the Report Header, it gets shifted downwards and the...
|
by: Andy M |
last post by:
ALERT
There is a person by the name of Mike Cox who's trying
to turn this mailing list into a Big-8 newsgroup. Many
of you know that this and most of the other postresql
mailing lists are already gated to Google Groups and a
small number of private news servers. If Mike Cox
succeeds, this list will be available as a newsgroup
on a great many more ISPs and NSPs, which could be a
good or a bad thing. For one, e-mail addresses on this
| |
by: Malcolm Webb |
last post by:
I need to produce mailing labels every week for staff, but not always for
the same people. I have found a procedure using a filter form which
allows individual names to be selected from a list box which are then
applied to a report for printing.
I have an Employees Table filtered via a query to only show current staff.
My FilterForm is tied to this query and the list box on the filter form
shows surname and forename. I can choose any...
|
by: antheana |
last post by:
Hi there,
I am trying to create a tblMailingList, but am a little stuck on multiple selections. The people that have opted into this mailing list will be given a list of different interests they want to be kept informed about e.g. services, special offers, 3rd party services etc.
At any given time, If I create a newsletter for services, I want to run a query to extract everyone who has said they want to be kept up to date about services. I...
|
by: razjafry |
last post by:
Hi Experts,
I have two tables- contact and organization. Both tables have the mailing addresses. Some contacts in contact table don't belong to any org so I give the link to those as individual which is an entry as organization in Org.. table.
There are certain organization which don't have any contact person listed. These two tables are linked as Org..as master and contact as slave.
I want to create a mailing list.Criteria would be
To...
|
by: divyac |
last post by:
I have developed an address book using php and mysql.I have all the contacts list in a table with check boxes.Now that i want to create mailing labels for the checked contacts...i.e.,the arrangements of addresses should be modified in such a way that there should be 5 addresses in a row of the table...I have done some coding but just dont know how to retrieve the checked contacts..Also..i have some problem in creating labels in which some...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |