I am trying to update a field called, CD2, in my table called, dmv01, which
is being done with an update query.   I have it partially working.  I want
the query to update CD2; however, it needs to update the records according to
the data that is located in the FIELD1 (which is in ...

hello world,
i have two tables stock and sales where one to many relationship is
created. The join type is " 2: include all records from  stock table
and only those from sales where the joined fields are equal." when I

I have an update query that adds 2 values together and stores them in a 3rd
field in the same table i wish this query just to run for the last record in
the table & not the entire table, what would be the query critera for this?

I have a table with 5 fields
ID  PersonID Date Amount and Type
I want a query with the last record of each person based on date and I
want the results like this

I have to tables with the schema below (see end of e-mail). I would like to
create a query that has an output like the following:
ID           SaleDate           Period
1            05/04/2006       1

I have set up a parameter in a query that will look between a beginning and
ending date. When I try to run it from a report, I get the following error.
This expression is typed incorrectly. For Example, a numeric expression may
contain too many complicated elements. Try ...

I have this SQL statement which I use to write a CSV file to a database table
from a Word macro:
   strSQL = "INSERT INTO [" & strTable & "] " & _
           "SELECT * " & _

I have a report that is query driven. It works great from two different
computers. A third user tries to run it and mysteriously the query changes
and she receives Error 3085. Then if I or another user tries from our
machines, we get the error too. I have figured out that ...

Hi everyone! Using A02 on XP.  
I have a query that is pulling all records ">=[StartDate] and < [EndDate]+1"
I also have a field [TurnTime] that is a calculation of
[DateMailed]-[Complete].  My problem is that our Turn Time Standard is five

I use a simple query to pull all the product indexes from a table:
SELECT DISTINCT tblIndex.ProductID
FROM tblIndex;
How do I get the query to use a specific index when the user chooses a

I have several tables in a database, tracking membership signups by
generation. Because it is important for us to track that each member gets 2
and only 2 sign-ups underneath them in a particular affialiate program, I
designed the tables by generations of sign-ups, starting with ...

I am trying to get records based on text in a Product ID field.  In the
select query, in design view, I have criteria as follows:  Like "*GAL*".  I
am looking for an item that contains the string GAL.  
What ends up happening is the operator turns into Alike and it doesn't work.

Two values in the text field seperated by a comma indicate the lower and
upper bound of the search range. Single values are converted to a range
centered on the value. The extent of the range depends on the precision given
for the input value; for example, 115.2 would be ...

Hi I have two tables:
tbExchangeRates
---------------------
erCurID                  1                            1

I have 48 fields each with 8 chars in each field. I need to combine into just
one field. I am using the [field1] & [field2] etc. however I can only combine
upto 255 chars at a time, any suggestions?