In a table i logg the error event generated by a program.
I memorise the err.description in a 80 char field
I would prefer to logg the err.number
When i consult the table, i am looking for a way to transfor an error

I have a Table which consist of two fields(Date/Time format): [Rock Dte] and
[Earth Dte]
example of data:
8/1/2005 1:00:00 PM    9/1/2005 2:00:00 AM

I want to select the last record for each item as follows:
Date
Customer
Item

I have a database that employees use to log billable hours toward
projects.
I have a Crosstab Query that uses a parameter to find a project numbe
and then displays the number of hours that each employee worked on

I'm trying to figure out why my append query is not getting any records based on a < date from a from field.
I can watch the form field in debug mode of VBA, but i dont know how to watch the append query field defined as DateValue([TIMESTAMP]).  I want to be able to see if the ...

This is what I have 2 created queries:
Query 1 is qry_Sum_for_Comparison_PP and contains the following fields:
PP_Shift_Date
PP_Shift  (i.e. 1,2,3)

I need to make a simple query that allows me to update data in one fiel
and have the total change in another field.
I have three tables:
Hours given

Does anyone know if it is possible and how to just add one field to a record
when importing from an excel file instead of importing the whole reocrd?  
Example, we have a contact database and everyone needs to have an e-mail
address and I want to know if i can just import that ...

I am struggling with a query that I am trying to produce. I have a list of
stock transactions (of Part Numbers) from which I need to identify only the
issues that have occurred since the QPA was reached (Quantity Per Assembly).
Part No.             QPA

i have two different databases that need to run seperate as they have
completely different functions. the first is the main database with all
transactions entered on one table, the primary key is [transaction number].
the second is a despatch system which needs to use the ...

I posted this message in the New Users section this morning, but didn't get a
response.  I'm not sure how this site is set up and if someone else might see
this and take a stab at it if I post it in the query section.  At any rate,
my problem follows:

I have a table called AVIN with two columns: element and ndate.
I would like to list all dates on which my table has an entry for an
element and that ndate, and has another entry for that element but
another ndate which is not more than 7 days after.

I'm using a user-defined function for a search criteria in a query.  After
upgrading clients to 2003, I get "Unrecognized function name" when I try to
run it.  The function is public and it should see it.  It even shows up in
the list when I use the Build window.  Please help.  ...

I have a table of 400 records where each record represents a specific
incident (theft, injury, etc) that happened throughout an entire agency. (The
table also specifies the agency site at which the incident occurred, but
that's a different nightmare...) Each individual record ...

Is it possible to order the results of my query by a field that sums the
values of 5 other fields?  For example query looks like this:
SELECT projid, tier,
(ASC(financial)+ASC(resource)+ASC(schedule)+ASC(technical)+ASC(alignment)) as