I really need some help.
I have two  formulas  in excel that I am trying to mirror in my access
database.
Here are the Excel formula:

I have a table names services with the fields ClientID, ContractName,
ContractNotes
I would like to be able to compare the notes from two different contracts
(year to year comparison).  I'd like the user to be prompted to [Enter Name

I want to set up an Access query that searches for letters in a string and
replaces those letters.
Can you get me going?
Thanks

Dear friends,
I have a tblContact with 60 colums. I need to extract say column 3 based on
value(202) in column 4, and 7 based on value (202) in colum 8 and column 11
based on value (202) in colum 12 -- into a new table.

Can you use DSUM and in place of a table name put a join statment?
Something like:
DSum("BPV_Economic", "tblUnits_ComboGroups INNER JOIN tblUnits ON
tblUnits_ComboGroups.SubUnitID = tblUnits.UnitID",

I think this may be answered in other questions, but I'm unable to tease it
out.
I've a pass-through query
select mem.empi,

I'm looking for some help with creating a query.
The fields are
user, case, location, units
I need a total count of locations, but whenever if the fields case and

I have 2 tables, with the same number of records.  I want to move the data
from 4 fields from table1 to matching fields in table2.  The primary key on
each table is different, so I cant join the tables and do an update query.  
How can I get this data across?

I am trying to get a running total on figures but am unable to do so. I can
get them to show up on a query but unable to understand how they can be added
together. Your help is appreciated.
SELECT OvertimeTracking_CrosstabodlTOTAL.Mon,

I'm having a braincramp. I want to count from the right 2 spaces and insert a
"."  so 12345 becomes 123.45
Also in the case where a dollar amount has dropped a zero i.e. 12.5 how do i
add a trailing zero i.e. 12.50  

Hello my name is Carlos, this is the first question I post, if you need more
infro in order to provide some help, please let me know:
I'm creating a Database to obtain the profit / loss of my clients (mutual
funds)

How would I go about in SQL - Access to display only part of a field
after a specific character?
For example,
In Invoice.Memo, there would be variations on the following:

If column a contains a word contained in a list from a table I want another
column to list that word.
Example Table Data
Comments                  

I have a form which has a query made up of a few other queries (this may be
an incorrect thing to do) as the Record Source.  
It has a three textboxes on the form in which I need each one to perform a
specific query associated with that textbox.  In other words, the user types

I would like to run a select query that groups the results by the number of
people already waiting.   this could be done based on either 2 or 3 columns.  
[arrival]  (a D/T field), [depart] (a D/T field),  and [Length_of Stay] in
minutes (a double data type field)