J
Josh
I have a query written in SQL as follows:
SELECT Vendors.VName AS [Payor/Payee]
FROM Vendors;
UNION Select Tenants.OccLNAme
From Tenants;
It gives me a list of all names from both my vendors and
tenants table for a drop down list on my form which i
like. The only problem is that it only gives me last names
of my tenants (it gives me everything i want for the
vendors) & i would like to add first name of tenants to
make less confusion. When i tried it gave me the
error "the number of columns in the two selected tables or
queries of a union query do not match."
---Any guesses on how to solve. thanks. Josh
SELECT Vendors.VName AS [Payor/Payee]
FROM Vendors;
UNION Select Tenants.OccLNAme
From Tenants;
It gives me a list of all names from both my vendors and
tenants table for a drop down list on my form which i
like. The only problem is that it only gives me last names
of my tenants (it gives me everything i want for the
vendors) & i would like to add first name of tenants to
make less confusion. When i tried it gave me the
error "the number of columns in the two selected tables or
queries of a union query do not match."
---Any guesses on how to solve. thanks. Josh