Excel has a "Harmonic Mean" calculation that I need to use in an Access
query. Is that possible? Formula in Excel is:  =HARMEAN(R2:R28) I would like
to apply this formula to a column of numbers on my form.

I have a query containing several calculated fields that produce true/false
as answers.  These are reported to the user as numbers (-1 or 0).  I would
like them to report as boolean (yes/no) fields so that they visually match
adjacent boolean fields, but I can't find any ready ...

Does anyone know if their is a limit of how amny fields (Row Headings)
there can be in a Cross Tab Query ?
I have one where there are around 65 & when I run it the data is not coming
out right but if I get rid of a few fields then the data is ok.

I have a table with the values as follows.  Note that thereare multiple
entries for each client ID.  
ClientID  DropOff  Farmer  PreSchedule    Duration
226              0   

I have a table called tblContracts where ContractNumber is the unique
identifier.
I then have a table called tblAmendments where there can be multiple
AmendmentDates for a single Contract and also has ContractNumber where they

Sorry I am struggling for months on this query/report.
my table looks like:
Proto ID
Week ID

Hi, I am new here.  How do I find Micosoft ACCESS users groups that gather in
meetings in eastern Massachusetts and/or New Hampshire. I already have
Microsoft Co's Boston group and the Boston tall building group.  Can you give
this request more exposure?

Basically I got a query which should look like this:
SELECT CustID
FROM Country
GROUP BY CustID

I have a little problem with my sql query.
The query is: "SELECT field1, field2 FROM table1 ORDER BY 2 desc"
I want to catch only 15 chars of the field 2. Anyone knows how to do that?
Greetings,

I have a mailing list in a table and I want to create a new table of 10,000
records by pulling out every 10th record from the main list.  Can someone
tell me how to do this?  I've not found the Access Help guide of much
assistance.

Three tables.  Many fields in each.
What would be the SQL code for the following.....
Only show rows of T1 where:
(T1_F1 equals T2_F1 and T1_F2 equals T2_F2) and

I am a self tought novice with Access.  I have built a Database which we use
to track IED (Improvised Explosive Devices) emplacements.  I have finished
inputting several months of historical data.  We have dates for these IED
discoveries and detonations.  I am trying to figure ...

I am entering information into two tables (Sales and Forecasts).  The Sales
table has an autoincrement field  (RecordID).  RecordID is then used as a
Foreign key in the second table (where it is a normal long).
I am using excel as a front end, and ADO to connect to the database.  ...

I have been working on a database to track our EOD teams missions.  Two of my
fields are 'Time Reported' and 'Time Responded'.  I have these times set in
the 24hour (Military Time) fromat.  I am trying to work a query to give me
the difference in those times, to calculate ...

I have a database with a query that pulls data from 2 tables.  The query has
requirements that one of two possible responses are in one column, and there
must be data in another column, with no data in a third.  Up until July 18th
of this year, the query has pulled data from the ...