I need to add an expression to a select query that returns the greatest of
several values - like the MAX(a,b,c) function in Excel.  
For example, I need to be able to create the "MaxSales" field by saying
MAX(WestSales, EastSales)

My table has field named CodeID that has 11 numbers. Ex: 10002562787.
In a query I want to pull  just  the last 7 digits of the field and not the
first 4.
Any ideas? What expression I can use in criteria ?

I have a button on a form which I would like to check if a text field is
empty or null.  I used [field1] = null  but this does not work.  Is this
correct?
Thanks.

I have a query looking up part# in a part#/part desc table
Some of the part # are missing so I want to query an older table for missing
part desc
What is the best way to do this???

I have a table that contains open and closed dates for each record. I want
to list the number of records that fit between these dates for each of the
last 12 months. If a record is opened in Jan and closed in Apr, it should
show up for jan, feb, mar and apr.

Can I have more than 1 ON statement on a LEFT JOIN?
Something like this:
LEFT JOIN Pacientes_Tel ON  Pacientes.ClvPac  =  Pacientes_Tel.ClvPac AND
ON Pacientes_Tel.Def = True

In my query, I need to group by only the 1st character of a field called
"text code" and don't know how to do that.  Can someone please help?
For example, codes like "A-KKC-OPE" and "A-DSA-IIP" need to be grouped
together.

I have an input form for contracts for a purchasing dept - when the data
input person inputs the contract, they need to select a buyer.  Each buyer
works for a specific work group - my field names are "BUYER" and "GROUP" - I
wanted to type in the buyers and their associated work ...

When I select a value in a combo box, the bound column value continues to
appear in the (combo) box - I also have a list box on my form that if the
user were opening up the form, they could click on an item, and see the
correct value in the field in my combo box, which happens to be ...

I need to split field "NAME" which looks like Doe,  John in two fields
"LastName"  (Doe) and "FirstName" (John) in order to make new table with the
fields LastName and FirstName.
Please help.

I have two tables:
Customer (fields: CustomerID, Name)
Orders (fields:  OrderNumber, CustomerID, OrderTotal)
Each customer can have multiple orders.

he he
Dear Folk,
The problem is when doing the count number like this SQL : example,
the field 'NUM' is the running num from 1 to 10, for example.

I have a table that contains 4 fields (State, Q1, Q2, Q3; while Q=Question).
As of now, the table contains 8 records.  I need to come up with some matrix
(crosstab query) that shows a count of "answers" in the most elegant way.
To make more sense of the data, I posted a small sample ...

I am using Office 2003 on Windows XP.
I need a SQL string that selects records from a table ([Table]) such that
the [High_Balance] for today ([Run_Date]) is greater than the [Low_Balance]
as recorded in the previous day's record ([Run_Date] minus one day) for each

I have a first name field in a query that has text in brackets after the
first name.  I would like to remove the brackets and the text within the
brackets.  How do I go about doing this?  Thanks in advance.
Janet