I am attempting to write a simple query and when I choose the information in
ascending order I am receiving an error message that states a record has been
deleted and will not provide the report. I'm finding that I'm receiving this
message on several already created queries. How ...

I have a query that uses a function to calculate the number of working days
between 2 dates.  The query works fine and returns the number of days.
I am using the query to get a count of records 'cleared' in over 10 days.  
When I put a criteria under the calculated field to ...

Is it possible to update / append data from a local table TO a Linked Table?
For some reason when I create a new Query - the linked table does not appear
in the list of available objects in the Design View of my Query.

I am using MS Access / Jet.
Problem is of hierarchial query:
I mean typical Boss Employee table:
Name                 Boss

How do I write a query to only pull back the most recent x number of records?
For example, sometimes I wish to pull back the most current 4 records, the
most current 22 records, and all the records.  I know who to do this in a
program using a loop with a counter and a NextRecord ...

I am using Access 2003 with no ability to switch versions.
I have two tables.  1 is the current inventory of Fuel Cards, and the second
is the new inventory of Fuel Cards.  I want to find all the NEW Fuel Cards
that exist only in the second table.

I would like to search for the word "and" in a query. How is it done?
cheers

I am trying to find every entry on list A that is NOT on list B.  So I am
trying to subtract list B out of list A.  So far, all I have been able to do
is get rid of the intersection, such that I have every entry not in both.
The code for that is

I have an Access (2002) application heavily dependent on query output.  I've
been looking for ways to change fontface, size, and color on-the-fly but
can't find anything.  I know that there are ways to automatically apply such
choices on a NEW query, but I can't find a way to do ...

in my database, I am recording projects in different categories. I
have now created a crosstab query that sums up all project per
category and year, including a total number of projects per year.
How can I also show, how the total number is changing compared to the

i need to make the following query
-mantable
    john
    david

How do I export a Table to a text file?
I need Fixed with and have a import specification.
I can import from a text file to a table but now I need the other way.
I have the table ready using queries and all I need is this last step.

In a query, I have dates (1st row), and a number (2nd row).
date1 -- 105
date1 -- 90
date1 -- 120

I often use aggregate functions in a non-grouped query when I'm writing
queries in T-SQL in an Access .adp server link.
However, when I try the same in a normal .mdb database I receive an
error about a missing operator.  The T-SQL is

I have two fields - ProgramEntry and ProgramExit.
I want to calculate how long a person has been in a program.  I can do
that with a DateDiff ("d",[ProgramEntry], Date()) expression.  But, I
run into a problem when they exit the program as it will keep adding