I'm trying to run a query that counts the number of people with
hemoglobin of type SS, type SC, and then all others.  There are about
12 different kinds of types.
Basically I want a count for SS, a count for SC, and then a count that

I have an Access program with several tables, queries and reports;
thousands of data points.
I have a field named "Capacity" belonging to tblCapacity which also
has fields plantCode, Year...

I have a names field that has inconsistent data in it. Sometimes it has a
FirstName and a LastName, and sometimes it also has a middle initial with or
without a period after it: FirstName MI LastName.
I'm currently parsing the field into FirstName and LastName. However, when

Hi I get a circular reference in the query from [H&W TOTAL OVER AND
UNDER].  I am trying to total the [TOTALS] from "H&W UNDER" and "H&W
OVER".  Can anyone help me.  I am having a really hard time figuring
this out.  Here is my SQL:

I have a complex query that uses LAT/LONG to determine if records are
within a specified radius in miles. - The SQL works, but I cannot seem
to get it to sort by the distance (alias iDistance)
Here is one the works - BUT DOES NOT SORT

I have a database used for change management and would like to be able to run
a query based upon a single record owner.  The field is a drop down combo
box.  I've tried the Like "Smith, Deb" but it returns nothing.  I've tried
with Like "Smith*" and it also returns nothing.  What ...

Is there a way to grab the top or 1st 5 records in a table?  So, if I have a
table of salesperson, I want to sort by volume and grab the top X number of
records only.

I have a crosstab query which includes a date criteria (ex 4/30/07). The
query works when a single date crtiteria is used.
However, when I update the criteria to include a parameter date range (ex
1/31/07 - 4/30/07) I receive the following error message: " The MS Jet

Does anybody know how I can do the following? I want to query a table to find
when one field in that table does not match one of two other fields. The
table in question pulls together data from several sources, and we want to
find results where the one field does not have the ...

I have made a 2nd query in design view and have the result I wanted but...
I would like to use this 2nd query as recourdsource for a form in vba.
1st qryTotal: SELECT tblInventory.ID, Sum(tblInventory.Quantity) AS
SumOfQuantity...

Have a numeric field that can contain numbers ranging grom 1 to 10.  about
90% of the values are 1 and I am mostly interested in the fields that are >
1.  I can limit the values displayed on a data entry/update form to only show
values > 1 by using an IIF() in the source query or ...

I've got a table with fields: ND, M, S, T, and P. The primary key is
comprised of those first four fields.
I have a query which is supposed to calculate a record's P (profit) as
a percentage of the maximum of all records with the most recent ND

  I am constructing a hydraulic fitting database to keep track of fittings
used and calculate replacement costs with the following calculation:
                 (([tblFtgs!fldFullStk]-[tblFtgs!fldOnHand])*([fldCostPer])))
  where fldFullStk is the quanity to maintain  ,  ...

I am constructing a fittings database and trying to calculate the cost of
replacing missing fittings.
I am calcularing the cost of each fitting that needs to be replaced by;
                         =(([tblFtgs!fldFullStk]-[tblFtgs!fldOnHand])*(

I am currently in the process of trying to work with a crosstab query in MS
Access.  In the rows, I have a list of names, and in the columns, I have
dates.  I would like the dates to be formatted as follows:
(First column for names)