Friday, August 12, 2005 5:46 PM
--------------------------------------------------------
I have never been able to run a simple UPDATE query in my Access setup.  
Here is what I get:

I have two queries.
One has the customer name and their values on questions 1 thru 5.
       fields cust_num, q1, q2, q3, q4, q5
The other has the question number and value for the question number.

SELECT project.proidno, project.prolname, time.timpe
FROM project INNER JOIN [time] ON project.propm=time.timemp
WHERE (((time.timpe)>Date()-8)) AND ((project.proidno) LIKE "C-*")
ORDER BY project.propm

I have a table with the following columns:
EmpName (text), CustAcct (num), DC (checkbox), DCDate (date), IB (checkbox)
and IBDate (date).
I need to know how to produce a report that counts each checkbox within a

I have a quary which I want the criteria expression to stated that it should
go from the previous week Sunday to the following Saturday each week with out
having to go in and change the expression each week

I have two tables that I am trying to cross reference.
Table 1 contains a single column list of telephone numbers
Table 2 contains two columns. Column 1 contains people's names and column 2
contains their telephone number.

I have the following query.  Several of the fields will have either a blank
RecordLocatorMain.DeskCode or RecordLocatorMain.RCDLOC.  I need the
combination of the two to be the same, even if one is blank, but my query
will only update those records where neither of those two ...

I have a field in my query [sumofonhand] with a data-type as currency
(because the table field is currency).  To eliminate null values in my field
I have the following expression in the query: sumonhand:nz([sumofonhand],0).  
But, the results replace null values with 0, but now ...

I have a form and a subform.  The form is main form with a subform main.
subform.  There are two fields on the main form that get added to the subform
after they are updated, they are Address and Apt.  I have an append query
which will add the Address and Apt fields to the subform ...

I have a "find duplicate" query which returns a list of users who are the
same but have different registration dates (ie they have registered more
than once therefore have different user id's).
How do I create a delete query that will delete the earliest date?

I have a Access 2003 front end/back end application.  A table in the back end
has a field data type of Yes/No.  I used the Upsize wizard to convert the
back end to SQL 2000.  It converted the yes/no data type to bit data type
with 1's and zeroes.  In the Access front end (which ...

Help.  I have an Access 2000 database.  When I run a select query, I can see
the full contents of a memo field.  However, when I export the same query to
Excel, the memo field gets truncated.  Is there some sort of limitation that
I'm not aware of?  Thanks!

Hi. I know NOTHING About Access..  I have Access 2000.
How do I fill in a field with data when the field is empty.  I would so a
search and replace but it does not work on empty fields.
Can anyone help me here?  Can you write the query for me?

I have a table with vendors listed and a table for stock items ordered I need
to run a query to find the vendor who has ordered the most items

I have a query that lists the number of truck drivers for each company, I
want to set up a parameter query that I can say show me all the company that
have