Is there a way to average the values of field within a query?
I have a query that determines the total minutes a task takes to complete,
this field is label “Minutes”. I would like to average the “Minutes” not
including the blank records, and the display the average minutes in a ...

I have a query “qryUrban”. Within this query are the fields “10-97Time and
“10-8Time”. The fields represent military time. I’m trying to find the
difference of the two times, but as you can imagine I have ran into a problem.
The problem being: If the “10-8Time” is 1359 and the ...

I have a two column table, the first column is a name and the second column a
value.
I need a PIVOT table query that gives me one row with column headings from
the first column and values for each column from the value column. E.g.

I am trying to count a single instance of a date that meets a condition.
such as count where a clas was taught by a a specific individual on a
certain date.
data is coming from a sign in sheet that has the date and the teacher.

Hello -
I have a column within a report that has several versions of a particular
entry. So I wrote a series of queries that would help to identify the
different versions, see below:

How can I have this process automatically done to have the data from a query
after it's been ran to be exported into Excel in a specified location?

Hi, I have a query that is causing me some grief. I have a table
(Subinventory Onhand with Cost) that contains a load of data, and the
essential fields are itemNumber and LotCode. I also have another table
(salesdata) that tracks sales for the past 12 months by month and item

Hello -
I have a column within a report that has several versions of a particular
entry. So I wrote a series of queries that would help to identify the
different versions, see below:

All: I have a table have several fields that I would like to modify
from its original text content to only retain its first 25 characters.
How to  do it in a query such that it could overwrite the fields of
that table? Thanks.

I have Access 2000 and one of the queries I am working on doesn't have the
design grid pane but have the tables with linked relationships.
Is it because of the version 2000 or some other reason? Can I restore the
design grid for that query by clicking some button?

I have the following select statement for my .mdb applcaiton and I get the
following error "Could not delete from specified tables"  Any ideas on what I
am doing wrong?
DELETE GBPEXCFMASTERCAF.*

I have two tables. Accounts and AcctDetails.
Accounts has two columns, Account and Desc.
AcctDetails has three columns, Account, Date, and Balance.
there are multiple detail lines per account, just will different dates and

I need to filter an employees training records based on the most recent
course taken. I have a number of employees that have taken extensive training
and have long employment histories. I can filter by what courses they have
taken but this brings up the complete list of all the ...

I have a MTQ that I am creating.  This is from a duplicates query that I ran.
I now want to condense the dups into one row.  The problem is in the last 4
columns I have YES and NO in the cell.  If one of them has a NO then I need
to have the condensed line have a NO.  If between ...

I have a dataset that I need to calculate quarties for.  This data set
contains about 20K rows with 200 or so job titles.  I want to be able to
calculate the first quartile for each job title.
I have seen some posts on calculating the quartile for a given dataset, but