I have the below SQL that obtains the names of property owners from the data
stored in tables.  The SQL adds the firstname, middlename, lastname and the
suffix together into a field called Property_Owner.  The question I have is
this, what if the property has two owners (most ...

Ok, below is the SQL statement for a query I want to run to find the list of
open disputes and combine the current list of disputes with the old list that
has the updated comments and such. When I run this, the resulting records are
duplicating. For example:

How can i call / run a query from a form?
Ex:
EmpCode: ---             [Find Record]
When the user clicks the Find Record button, the query is run which would

I am trying to build a inbreeding query.  The basis of this is that I need to
find dog's in a certain pedigree that have the same ID number
Below is just PART of a pedigree query.  Much more is involved.  
SELECT tblDOG.ID, tblDOG.name AS dogname, sire.ID AS sireid, sire.name AS

I would like to put in a sales number into a form and have the query calulate
what the royality and ad payments would be and then update those amounts into
the table? I will giv you an example... I have a form that updates my sales
table I put in the sales number into the form. ...

I need to take a text file with a list of numbers that are formatted like:
80012345
91290999
89894566

My SQL view is below.  Here is what I have.  Two seperate tables that I am
trying to bring together.  I have created two Queries and what I am trying to
do below is calculate the percentage of the employees errors compared to the
volume they have processed.  I have joined the ...

Is there an easier way to code this for a field in a Query for a report.
The field will be in the detail section.
Thanks
DS

What command would I use to find the position of the first alphabetical
character in a string? Example: 145-54A = 7, 12-54CG = 6. Would use InStr if
I knew how to indicate "any alphabetical character" in the string2 position.

I have an "update table" that I need to update to my "main information",
however, I only want the update to happen if the numbers in the "update
table" are larger than the numbers in my "main table", or if my "main table"
is blank I need the number from the "update table" to be ...

I'm developing a database to store and analyse contract information.  I've
normalised all the tables and created the relational db and am in the process
of creating the screens and links etc for the process flow.  As part of the
flow for creating a new contract I need to enable ...

I am receiving "Error 93: Invalid use of null" when trying to run a query
with criteria in a certain field; the query runs fine without the criteria,
but not so much when I try to specify one.
The expression of the field in question is:

I have a transactional table called SBMSALE2008 that has fields called HPKey
(the primary key), PartNumber and another called HPProductLineCode (along
with several other fields).  The ProdLineCode field is blank.  There is
another table called Products that has two fields ...

I have a table called Products that has two fields: ProductNumber and
ProductLine.  There are about 2000 product numbers. The ProductNumber is
alphnumberic and can be 6,7,8 or 10 characters.  The ProductLine field is a
alphanumberic characters.

I have a single table with two ID fields.  The second ID field is a cross
reference to the first to show a link between two separate entities.
ID1        ID2
001