I have two tables with one table being updated.  The update query works fine
in design view, however, when I go back to the table to view the results, I
don’t see any values where there should be.  Has anyone else experienced this
problem?

I am working out of two audting databases for a call center with the same
information except for different scores. I've built macros to import data
from both databases into a thrid database for analysis. Is there a statement
i can put in the criteria of a query to find those ...

I have a branchNo that is a text field.  It looks like this: 21, or 61, etc.
I need the field to have a trailing zero to look like this:  210, or 610, etc.
There are about 2000 branchNo that need to be changed.
Does anyone know how to set up an Update query to add the trailing zero ...

I have a database that I want to be able to query by having a drop down list
or a list where a user can select more than one value or posibly both. Can
anyone help?

I am trying to write an expression for an update query, that will capture the
middle name/initial from a [Name] field that is formatted as "Last, First
Middle/MI". The problem is that there is not always a middle name/initial. So
some data is formatted as "Last, First". I need it ...

I have 30 columns of data values equal to S, M, or L.  I would like to
compare these values to a reference table and return the corresponding scores
5, 3, or 1, and if no value is found, return a 0.  How do I set up my query
to do this?

I have a query that is parameters set to run from a form with a beginning
date and an ending date.  The field is a Date/Time field, set with hrs and
mins to show as well as the date in long format.
My challenge is that it would just run for one date i.e. Jan 04/05.  If I

I am trying to run an Update query in SQL to a memo field.  I get the
error message 'Item not found in this collection'.  I have posted my
code below.  Anyone got any ideas what I am doing wrong?  Any help
would be greatly appreciated.

I am running a query through a macro/VB Code.  Each time the query runs the
system asks if I want to update and I click on YES.
How can I force a yes or how do I stop the system asking the question.
Thanks inadvance for any help.

I have a query where I calculate the elapsed time by subtracting Time
Out with Time In (24H time, no date in the timevalues). The problem is
that some of the Time Out-values are not available, thus the
calculation gives me a negative timevalue.

I am trying to run a query on two tables to find the last name and first name
pairs that do not apear in both tables. I can obviously get the union but how
do i get the difference. Thank you for all your help.

i've successfully used a function result as the criteria for a query in
access mdb database (as in KB210388) but i cant use the function in a similar
query in an ADP database. I get the error: "ADO error 'functionName()' is not
a recognized function name". Can anyone show me how ...

I have a query that lists all our Part Numbers and the Work Orders that have
been created for those parts. I need to be able to display the 3 most recent
Work Orders for each part.
The data in would look like this:

I got the follwoing DSUM FUCNTIOn: DSUM("APIMvmnt","HealthProduction","
[broker]=1000012946 ")
I wouldn't like to specify the broker number in the criteria part because it
only returns the values associated with this broker (1000012946),This formula

I have a table that contains, among other things, phone numbers and the
dates that they were called.  What I'm trying to build is a query that will
allow me to enter a beginning date and an end date, and then give me each
number that was called during that range and the number of ...