I am very new to Access and would like to calculate the median of various
groupings of data - I have no trouble grouping by average, min, max etc. but
I don't know how to calculate the median.  Any help would be much appreciated.
TH

I have designed a report based on pass through Access Query that pulls
data(via ODBC) from SQL Server back end tables. One field in SQL table is a
memo text and the length is way over 255. I need to pull this filed as is
into my Access 2003 report.  So far, the memo filed shows ...

I have an access db that I use to  manage the updates and maintenece
of our SQL based web data. One of the functions is to update the filed
to note when we have a product image.With some help several years ago
from this group I was able to get the following code to work. This

Is there a handy way to search all queries in a database for the presence of
a particular text string in the criteria?

I have a query that has the names of employees and the dates and hrs. they
did a job, about 10,000 entries from Jan to present.  How do I make a query
total the time by month for each employee?
Thanks!!

I work for a small homeless shelter.  I have a table called "Services"
that contains records with a ServiceID, GuestID, ServiceDate, and
ServiceType.  The total number of records is the total number of
services we have provided.  Such as:

Hi - I have a table "Data" which doesn't have required fields for each
record.  What I'm trying to do is use a query to find the last value input in
certain fields.  Currently, instead the result is '0' since the last record
doesn't have any data completed.  I'm not sure how to ...

Heya im pretty new to access.
I have a table which is a list of names (all the people in my office) Called
'Names'
I have another table which has a list of dates for a month. Its filled in

I have a table that contains the following fields:-
ID
REF_ID
OUTCOME

Hi,
I have the following expression in the criteria of [Security Type].[Security
Type ID] field in a query:
IIf([Forms]![frmLookup]![TypeSelect]=1,[Security Type].[Security Type

I work for a small homeless shelter.  I have a table called "Services"
that contains records with a ServiceID, GuestID, ServiceDate, and
ServiceType.  The total number of records is the total number of
services we have provided.  Such as:

Can anyone PLEASE assist me with my SQL Select query?  I have a table
that keeps track of user login information so there will be many
records for a given user.  I have 5 boolean fields which are displayed
as check boxes (reference library, quotes, tracking, training,

I am putting together a Days To Ship report and want to the Lag time data on
my report. All I'm looking for is, an order comes in 11/02 (Fri) and Ships
11/05 (Mon) the output should be 1.
Any thoughts?

I am putting together a Days To Ship report and want to the Lag time data on
my report. All I'm looking for is, an order comes in 11/02 (Fri) and Ships
11/05 (Mon) the output should be 1.
Any thoughts?

I'm trying to combime the following three queries into one sql statement
but I don't seem to be able to get the syntax quite right. Can someone
please help out?
TIA,