Please Help.  :-)
I have two tables that have two fields of addresses. I want to create a query
that can campare the first 5 charecters of these fields only.  For example,
1223 Back Street   and 1223 Back St. shouldn't be executed because they are

I've been reading other posts and I'm still confused.
Here is my problem. I have records that have 6 different test scores. I want
to find the total of the lowest 4. I know access is not excel but this seems
like this should be easy to do. So I have [Student], [Tests 1-6] and I ...

I have many too many queries, which I use to gather data for a report.  I
hope someone can suggest how to consolidate them.  For example, 8 of my
queries are of the exact same form, except the value of one field is one of
8 possibilities.  Here is the SQL for the qCUS query:

Is there a way to display column total in a query?
I have a query that gives me Prior year sales and current year sales but I
would like to include column totals for both columns. Is this possible?
Here is my query.

I want characters 15 & 16 of a 16-character field.

I am developing training material to teach how to use crosstab query wizard.
My example is to show how many employees were hired each year for each
department. I chose department name for row headings and "Hire date" for
column headings and selected "year" for the interval and ...

(To start, I hate the way our database managers setup this database.)
One of our databases is setup such that when a price adjustment is created,
the row of data reads something like --
FROM          TO        ADJ

I have a crosstab query I am using on a form with a subform.  For some reason
I can not get the columns to change when the dates change in query.  Please
help!
The following is my SQL Statement:

Can someone help me with a query.
I have a table like below
ItemNo    CostType
12345        a

I'm working on a query that counts how often certain types of contacts
happened between staff and clients, how many hours were spent on those
contacts, and how many clients were involved.  For example, let's say, in
Feb. there were 10 visits between 7 clients.  Those visits came ...

can anyone see what i am not see...the sql bellow give me a syntax error on
join operation, but i dont see where. is it because there are too many joins?
SELECT MSM.ModelNumber, MSM.Desc1, MSM.Desc2, Spring.Spring, Label.Label,
Size.Size, Needle.Needle, Pattern.Pattern, Config ...

I have a query where in one column I have a calculation that is suppose to
return a "G", "Y", or "R".  However, due to non-existing values for some
instances of the data used in the calculation, I get "#Error" for those
values.  However, I'd like to get the "#Error" to be ...

I currently have a crosstab query that I used to count the number of each
type of employee compliant and summarize by quarter.  For example:
                              Q1           Q2           Q3           Q4
Human Resources      1              0              2             1

When I copy text from a formatted survey type word document, and try to paste
it into an Excel spreadsheet from the same source, the text will split up and
spill into cells below it, even though the cell size is easily large enough
to hold it. Sometimes it will spill to multiple ...

I want to use an inputbox in the Form_Load event, and then use that input as
a parameter in several queries.  Is that  possible?  How would I put the
input values in the queries?  (My form uses the data from several queries.)
TIA