I followed/modified the "Criteria" in Microsoft KB Q153747 but do not
get the desired results. Instead of returning the Top-10 per Group
(LOC) I only get the Top-10 across all groups ... the same as if I use
the Top Values box in the query design tool bar.

This is my SQL statement:
SELECT Abs(Sum([Form2]="Filed")) AS Unit1Form2Filed,
Abs(Sum([CAMT]="Filed")) AS Unit1CAMTFiled, Abs(Sum([Form2]="Req & Rec")) AS
Unit1Form2ReqRec, Abs(Sum([CAMT]="Req & Rec")) AS Unit1CAMTReqRec,

I am trying to add a column of information based on values already in another
column in the query.  Specifically, I want to put a value in Column.AreaCode
based on the Leftmost 3 characters in Colunm.PhoneNumber -- basically I have
a list of contacts outputted by another database ...

I have downloaded employee information from a corporate mainframe into a
table named EXCEPTIONS.  There are two fields named Employee and Date.  The
Date field has dates employees have been absent from work.  I want to be able
to identify those employees and the dates they were ...

I am taking over a database for production.  The manager wants to see from a
QA table the counts of product that have a "pass" of "fail" attached to its
inspection.  I found a "counta" function in the microsoft support pages, but
the QBE form does not recognize this function.  ...

Can anyone help with this error
This is my code and it keeps falling over at the and keep getting error that
the join cannot occur:
       strSQlCS = "UPDATE tblinventory " & vbCrLf

I have a table with over 100,000 records. Only 26,740 are unique, meaning
that their customer number and customer name are the same. The reason they
are duplicated is that many have multiple account numbers. I have copied all
of the customer numbers and all of the account numbers ...

If I want to run a query and have a parameter set to ask a question, what do
I type in so when it prompts the user to enter the worksheet ID, they can
type only a few letters and it will bring up anything that starts with that.
example of parameter:  Enter the Worksheet ID

Good day,
I need to run a number of crosstab queries where the column headings is
based on race.  The row data will be either male or female, while the row
heading could be Faculty, department, ect. At the end of the day the male

Can someone help me and explane why below potions do result in a difftent
number?
Query:
SELECT tblPersonnel.ShortName, tblPersonnel.RPExpDT,

I would like to drop all the indexes of a table (or of the full database)
without knowing the number and the name of the indexes.
Could you please help me ?
Regards,

I have 2 columns in a Query that contain expressions. I have created a third
column with an expression in the same query from those first 2 columns. I'd
like the first 2 columns to not appear in my Query but when I click off the
show buttons it's messes up the 3rd expression. Why ...

Thanks to  arthurj...@gmail.com for the response on the subqueries. I
now need to take this a step further and add a couple of calculated
fields into the mix. I've tried a variety of versions this morning, but
I'm getting nowhere. Can someone help?

how do i delete duplicate phoen numbers

I have a database that tracks cost information for our products. Currently, I
have an update query that allows the user to change the price information.
Additionally, I have a macro that emails the results of the query. I would
like to be able to put the results of the update ...