would like to extract all of these elements:
int.de.sh.k.wand
Left([string],InStr([string],".")-1) gives "int"
would like to be able to separate out de, sh, k, and wand as well.

I am using a simple select query to edit table data in an MS SQL database. I
would like to be able to change all of the fields to be modified then have
them update the table as the process works now. Any suggestions?

I have a list with following information:
Invoice    Item    InvAmount
10514    1    $3,210.00
10514    2    $3,210.00

I am working in Access 97. I have the following query:
SELECT tblPromo.UPCFip13, tblProd.ProdDesc, tblPromo.PromoNo, tblPromo.UOM,
tblPromo.StartDate, UCase(Mid([StartWkdy],1,2)) AS [START DAY],
tblPromo.EndDate, UCase(Mid([EndWkdy],1,2)) AS [END DAY], tblPromo.Price,

I want to create mailing labels that will print the preferred address for a
contact. I think the query should follow the logic -- If preferred address is
home, then print home address fields. If preferred address is business, then
print business address fields. Currently I have ...

I have a db with asset tracking information for server hardware.  One of the
pieces of information, which is also in it's own table, is the applicaion
running on the server.  I want a query where I can select an application from
a list and have it return the servers that match.  ...

I have a crosstab query running that has empty fields in the records
results.
Is there a simple way to have a 0 zero displayed instead of a blank filed.
I am counting the crosstab fields.

I am not sure how to go about this, but I think a query is my best bet.  I am
trying but have not come up with an answer and any help would be appreciated.
I have a table of values and use a couple queries to manipulate the data
(mainly math stuff) to get it to this point.  The ...

I'm creating a database to track commission. I have an Invoice Database that
records the amount of each sale. There can be multiple Sales Reps per
Invoice. So I've created a table called SalesPerson Invoice. There is a one
to many relationship between Invoice & SalesPersonInvoice ...

This might not be the correct forum to ask this question, please redirect me
if not.
I have a parameter query that selects data by date.  The dataset is simply
the following set of fields:

I have date and time fields in my table.  I want to run a query where I only
get the records with the most recent date and times.

I have a form which is used to plan exercise sessions for clients. It is made
up of combo boxes with choices of types of workouts that have been complied
in other forms. I need to a: get the combo boxes to choose the correct
queries based on the choice of each box ie in mondays ...

In a query I want to take a Table Field - Employee Number and covert it to a
new Field EmplID which is text.
I wnat the Field records to be 6 places.
I have not been able to figure out how to input zeros.

Is there a better way? There are so many iif() statements. By the way, the
NZ() statement fails... you see, I run these querys from an outside
application through Jet and ADO. Also, for the same reasons, I need to pass
the parameter as Text, then convert it, otherwise, the ...

I am running an append query and would like to be able to have it ask me for
my date ranges ie. Between #??# and #??#. Not exactly sure how to do this.