looking for a letter template to advise creditors that I am unable to satisfy
a loan.

I created query name Total Amount query.  In this query I am calculating
total for each order.  The last column in this query is Total_Amount then to
get all totals I put the following code in field row for this column:
Total_Amount ...

I am trying to append a set of records to another table, but not all records
are being updated.  Is there a way to get a list of which records were not
transfered and then what is the problem with each record that was not
appended?

Please help,
I am trying to create an update query to update teh # of subscribers in
my database.  I have all subscribers listed by area and want to update
the area table with the number of subscribers in the data base.

how can i set the date to show on financial years. I cannot believe this is
not a function already waiting to use. can anyone help???
Thanks
kate

How do I insert a string/integer into a table using a value obtained
from a form. I seem to get a type conversion failure for some reason.
I've checked the fields (source on form and target in 2nd table) and
both are long integers.

Hi,
I have two questions:
1. I'm trying to do a FULL OUTER JOIN in Access, but it deeps on saying
"Syntax error in FROM clause".  Here's my code:

I am working on a query that will select rows of data where each row contains
as many as 35 different dates.  I would like to create a new field at the end
of each row of data where the earliest date in the row is returned in the new
field.  

You all have talked about this ... I haven't seen an answer quite matching my
problem.
I have an empty MS Access 2000 DB (structure only) and I am looking to
populate it with old records into the new structure. So it is a conversion.

I'm trying to have my query output the current month minus one month: So if
it's October I want it to show up in my query as September. This is what I
have in my Field: Current Month: Format(Date(),"mmmm") but I can't get it to
show September. If tried -1 but I must have in the ...

I have a select query that shows an employee's last day on payroll.  For a
mail merge I am working on I want the query to show me the last day of the
month.
For example

Hi,
I have two questions:
1. I'm trying to do a FULL OUTER JOIN in Access, but it deeps on saying
"Syntax error in FROM clause".  Here's my code:

Hello all, I have a query where I need to count the number of records
and then I need to count the different number of instances within that
same column.. Here is the code that does not work.. I want to know the
total number of trees (44)from plotnum and then how many different

I have a cell that the length varies and I need to display from the end of
the data up to the space if the 1st position of a cell is "I or N".
Ex: I   NN0NN
    N  NNNNNN

How do I group by date in a query if the Date and Time is combined?
James