Want a cell to enter "0" for values = to 0 or <0, and then take the positive
difference in that same cell and put it into another cell.
ie:  In the worksheet I have a descending loan balance that will be
progressively  reduced to zero from positive cash flow until the the loan is

Hello, I am building a parameter query using query by form. The form has 3
criteria: Physician Name, Start Date, End Date. I have used IS NULL in the OR
criteria for the Physician Name, so if that field is left blank, then all the
physicians will show. So far if I put in the ...

I am creating a  DB in Access 2003.
Tables:  Client  - Careworker - Placement
Query: Placement query
The Placement query is linking  the 3 tables and keeps records of

How can i reset an identity column using a SQL command? i'm using Access 2007

I have a parent table with 3 children tables. Each of the child
records has an activity date on it to represent a change to the
record.
The client wants a query where any parent record where 1 or more of

Access 2002
4 Fields, 1 text and 3 yes/no
Group on the text field and count the number of each yes/no fields
individually, the query wizard just adds all 3 yes/no and puts the count in

I am trying to find duplicates from a table and then limit those records by
selecting lines where my ID field contains different data. For example, I
have dupliacte records from a insurance claims table and I now want to show
claims where a doctor is using two IDs to bill claims.

I am working in a venue tracker database and I have a look up box in the
header, searching for a venue name in alpha order.  The problem is, we have
many venues that start with "THE," so searching is not as easy if you don't
remember that "the."  How do a break apart the field to ...

I havce a select query that always returns 77 rows.  This is exactly what is
suppose to be returned.  The users are now asking if there is a way that at
every 20 rows the header information is repeated.  Is there a way that this
can be accomplished?

I need to use "Last_Day" function in Oracle. For example,
SELECT NEXT_DAY('02-FEB-2001','TUESDAY') "NEXT DAY"
    FROM DUAL;
NEXT DAY

I have many reports and am trying to use a function to display a message
when there is no data in the report: "Report has no data."
The function seems to work in that if there is data, a report runs with the
data. However, if there is no data, the report does not run but "Report ...

I have a query with a union that  works fine, which sorts my records has I
want, nevertheless I wanted to add four totals at the end of the query, in
order to do that I joined them with union all otherwise it would screew up
the sorting if I only used the union clause. But ...

I have a table the stores the following data. The table name is tblTracking.
The fields are Product, Equipment, Results and Date. The results have 3
lookup options, passed, failed or not sure. I need a query that generates
data for all products and equipment that has 3 ...

Is it possible in one query to count the total number of records in a table
AND count the number of records in the same table which meet a criteria THEN
append this information to another table? Or should it be done in steps?

I have a crosstab query that counts the number of occurances for every
location.  The query is set to read a location table and an issue table.  It
then creates an output that displays all locations, and the count of how many
issues are for each location.  However if a location ...