I've been thinking the problem is woith my computer's regional settings,but
it's not.
I got this excpression

I have names in a table in the format Last, First.  I would like to split
this column in a query to creat two columns for last and first.  Is there a
way to split by the comma?

Hi  using 97 crosstab query,
Is it possible to get Top 20 customers and the rest group as OTHERS?
Example, I have 240 customers so I want to
Sort by descending to get top customers. So I want to take the 20 and the

I am having some trouble on what should be a rather easy solution...but for
the life of me..I am stumped.
I have a field called customer name.  A customer can be:
An individual shown as (Last Name, First Name)

I have a form with a check box and it previews a report through
query.  I have a meme field that has "This is a speical material" an
other information in certain records that are considered "Specia
materials."  In my report i would like to pull up a list of thes

I'm downloading data from a ODBC source over which I have no influence. The
data is patient admission, discharges, unit assignments (and a few other
fields.)
In order to the the last admission, last discharge, and last unit assignment

One:
I have a master list of companies with unique companyid (primary Key) for
each. This table is not to be updated.  Looks like this:  
1; abcCompany

I want to be able to Update one record based on another in the same table.
So for example I want to update the "ChangedDate" of the record that has the
FairValueID=92 with the "ChangedDate" of the record that has the
FairValueID=89

I have a table(Master)Name
--------------------
Buchanan
Callahan

I have 2 tables - each of the tables have an account numbers field
Table 1 has most of the accounts with data filed populated
The 2 table has an account that has data but is not in the 1st Table
I cannot get a query of return all accounts with data from both fields , I

Which is it  the difference between the two formulas in a query ?
(format Standard decimal places Auto) r:[field km]/([field hours]*24)
without CDbl
and

I want to create an Incremental Number field for this Make-Table Query which
is based on the records from another table. So each line of records in the
new Table has an incremented number starting from 1.
Do I use the ALTER TABLE statement? and how...

What is the difference of :  IF and IIF
I need to practice programming in access. So can I get some problem.  

We have recently converted a database from Lotus Approach to MS Access. We
are trying to create queries in order to search 6/7 fields. We see that we
can create queries using the wizard, but cannot figure out how to execute the
query. Based on what the built in help suggests, we ...

I am trying to run a query based on a single table, although the field that
I'm trying to extract with criteria is linked to another table. I can sort by
adding criteria to any field except the one I want to. When I add criteria to
the field I want to extract, I get no results. I ...