Running an append query to a table, the query is merely a select from
a pass-through query, which works. Previewing the result of the append
query works, but running it does not.
"Record too Large"

Please help me translate the UPDATE statement listed below so that Access
SQL can execute the SQL statement.
Thanks,
UPDATE suppliers  

How do I put in the criteria in the SQL query design view to filter the
records that do not equal three product number. I put this, but does not work.
<> "A123-847" OR "A123-878" OR "A123-232"
I guess the criteria must be wrong.

I have a query that one of the fields can have repeated values because it is
repeated in the table it comes from. I would like to only have one of the
repeated fields.
For example:

I have an external medical billing database I am linking to.
I am working with 3 tables   Deposit, Payment, Transaction
When creating a transaction (medical procedure for billing) a unique charge
entry# is created.

I have a query that creates a crosstab query. I want to be able to use the
parameter between (date) and (Date), however it will not allow me to the
query gets messed up.
The way it is now works however, I am one of two people in the office that

I'd like to add checks to some checkboxes with an update query.  My guess on
how to do it looks like this:
UPDATE FCNsOnTheWeb INNER JOIN ScanTracking ON FCNsOnTheWeb.TextField2 =
ScanTracking.TextField2 SET FCNsOnTheWeb.ScanningComplete = "yes";

I am using the following in a textbox, the output is totaling the whole
field. How can I get to sum the current record instead of the whole field?
=Sum([actdate1]-[rprdate])
Thanks...

I have created a simple database with a query that is getting its
parameters passed to it from a form I made.  The issue I am having is
twofold....
First, I can't get the "ALL" choice in my dropdown combo box do do

On my from I have an option button that limits the list in a combox to Active
employees. When it is not checked I would like the qry to return all records.
It works fine for when the option is true but not for when false (right now
it returns none). Can you see where I went ...

I'm working in design view of Access..specifically try to validate a field,
to check to see if it is in a specific date format.  So, my example is below:
IIF([column1] like MM/DD/YYYY HH24:MM),"its a valid date", "not valid date")
So, I need a way to check for the given date format ...

I'll do my best to explain what I want to accomplish, and perhaps someone can
point me in the right direction.
I'd like to create a form, where the user can select records from one box (i.
e. Active Stores), and click a button to drag them over to another box (i.e.

How do I reverse a name in a field?  I have a column with names that are in
this order:  Last, First Mid degree = Clooney, George J., MD change it to
read George J. Clooney, MD.  However, if there is no MD, I do not want the
name to change.

This is a two part question. I am new to Access SQL having used PROC SQL
(SAS) historically.
1) Does anyone know where I can find a site that has a comprehensive list
(or a book) for ACCESS functions? I have tried without success to find this

What's up with this?
I have a query, and the first field is a prompt field to select a set
of records.
The second field is named [Fielding Slot] and is a text field. There