I have two time fields in a query in h:nn:ss format.  One is an average time
for a function for the last 60 days the other is an average for the current
day.  I subtract the current day from the 60 day average to compare the
current average to the average.  When I perform

I have a table that has a yes/no field in it called "completed", when I
create a query based off of this table this field shows as a 0 or a -1.  How
do I code this so it will show either Yes or No?

I've got a reasonably simple application that I want to dumb down further for
a novice user.  We recieve quarterly data in three Excel files of which we
combine into a single tab and inport and keep as a separate table, "just in
case" we want to look at history.

i am running a query that simply links several odbc tables and queries. when
i run the query, access shuts down and the program exits entirely. all i see
then is my desktop. any ideas what could be happening?

I have a report that I've been constantly working on and have posted several
questions to this particular report. I'm at a new stage and seem to be stuck,
again! This is what I need:
I have a report that will display data using a crosstab query. The text boxes

Good Morning,
I have created a database to act as a "customer service system". The current
process for handling customer complaints and queries is by a scribble on a
scrap of paper and so that's why i built it. Because i don't anticipate the

I have a query to export the content of a memo field to excel. The query
result cut of some part of the text. How do I overcome this problem?
SF

I am a new access user, currently trying to build a database system for my
musicschool.  Has been reading quite some books but none can answer some of
my needs.
I am using access to generate receipts for the students.  My students pay

Access 2003
I have a large database with several tables. One of the tables has about 74
fields and I have created a quety using only 12 fields and criteria to
filter only certain records. I need to send the results of the query

Table/Fields
Students/ Student ID, First name, last name....
Tests/ Student ID, Test Name, Test Score, Test Date.
I need to be able to find students based on their record of tests. For example I need to find each student who got above a certain score on 3 or more tests ...

I have created a query and I have placed [enter date] in the "criteria" so
that when the query is ran, the user has to select a specific date to return
those results.
My question is, how can I create a similar query where the user can search

Hello there, My ultimate goal is to have a query that has two columns that
return these results:
Column 1: Sum ([total cost]) where [place of service]=21
Column 2: Sum ([total cost]) where [place of service]<>21

I have a rather simple table, about 15 fields.  Is there a way to
build a form and or query that would have the user select the various
fields they would want in the query result?  The way the show check
box works in the design grid, but more in a form type look?  Any

I have a table with about 10000 records.  It's set up like this:
tblFrogs_and_Toads
PK
Date_entered

I have built a multi-table select query and right now all the relationships
between tables are the default "show each record in tblXXX for each record in
tblYYY".
When I run the query, I get only one record and it is repeated eight times.