...I'm sure it's possible.  
I have a table that shows each month of the year.  During each month one
person is assigned to complete a certain # of reviews for a CSR during the
1st half of the month, and another person is assigned to do reviews for the

I am trying to run an UPDATE sql query in a module. I get the 3144
error but I'm not sure where the error is. Any help would be
appreciated.
Thanks

I have a table of nominations that includes the fields NomineeName,
NominatorName, and NominationMessage. I did not create the database, but have
been asked to create reports from it. My problem is in the NomineeName.
Users have been able to imput multiple names into the database ...

I have  2 linked tables from 2 different databases, there is a common field
in both: “CORP_NBR”  I need this field in order to create a join, but the
problem  is that in one table this field stores leading zeros and in the
other table it doesn’t. I can see in design view that ...

I have a field of data in an Access query and would like to test whether the
average is significantly different than 0. That is, I need to run a t-test,
but cannot figure out how to achieve this result. I can do it in Excel with
the data analysis add in, but I am hoping someone ...

i have a problem ; how to solve that first let give you the table structure
that i have
i
1) [Sno] number

I want to filter records in a simple query, but based on the contents on a
text box in a form.  However, I want to use the criteria only if the text
box is not null.  The query works fine when there is data in the text box;
but I'm having trouble returning all of the records when ...

Hope you guys can help me, for this conditions;
From "referrence" database i have a numbers which have a range and need to
match to result database i can call "to match" table to get the real
conditions.

Why can't my set work?
mySQL2 = "INSERT INTO Kanban ( PartNumber, K_Qty )" & _" SELECT '" &
strPartNumber & "', '" & strPositive & "' from WIPRawDetails" & _" WHERE
JobNumber= '" & Me.txtJobNumber & "' and PartNumber = '" & strPartNumber &

I have two tables, table I contain addresses complete with five (5) digit zip
codes. Table II contain a range of five (5) digit zip codes with a state
designation. I’m tying to create a query in Access that will look up the zip
codes from table I and assign the corresponding ...

I have a simple query that I wish to use to search for titles of Music CD's.  
I wish to establish a parameter query that will allow the  user to enter a
word and the query looks for that word in the title.  I have lried .....Like
*[Enter the word]* in the query designand various ...

I have a table of the following format:
Weather               Date
Wet                    22/04/2006
Wet                   25/04/2006

Working with MS-Access 2003, I want to perform an update query that draws
it's data from a select query.
There are 3 tables:
-SoloData

I have two tables, table I contain addresses complete with five (5) digit zip
codes. Table II contain a range of five (5) digit zip codes with a state
designation. I’m tying to create a query in Access that will look up the zip
codes from table I and assign the corresponding ...

I am looking for help to determine a formula that will let me
determine which children who will be 5 years old by Dec 1, 2007. in a
query
Col