I am updating one table (one time only) having 15 of the fields change from
null to 0. Text fields.  Yes, I mean to do this.  When my query updates one
field at a time, it updates fine.  
I cannot get it to work if I ask it to update all 15 in the one query --

Microsoft Access 2003
I have a query which is pulling from several numerical fields.  Each
field individually shows up fine, but when I try to get a total of
several of the fields together the total field ends up blank.   Here

I have an AppendQuery that add two rows when us it at 1st time.
Why, please?
Thanks in advance.
an

hi all,
once again i find myself in need of the expert advice i have always found
here.
i have a series of alpha/numeric values in a table column like this:

I am trying to query for the following records:
FFA-QSC6010 and SURF-QSC6010
I have tried a number of ways but it continues to bring up all records.  Any
suggestions?  I would like to just search for any record containing "6010"

running access 2k;
I have a query that uses a crosstab query as one of the tables in this
query.
I cannot even open this query in DESIGN view without getting the too

Here is my problem:
I have a "Parts" table with a "Part#" field and am trying to create a
relationship to the "Orders_Shipped"  table and the respective "Part#" field
in that table. It works fine except for the "Part#" field in the

How can I get a user input for a query. The users input will be used in the
"where" field.
For the example below, user will type the name of the student.
Select Rank, Score, School From StudentRecord Where Name={{User inputs the

I have a query with numerous fields. Many of the fields are text. I want only
want to query out records that are not blank in each of the fields, so I was
wondering if there was some code I could put in the criteria of each field
that will exclude null or blank values.

I have a number such as 288E3334 & 288E3334-001.  I ask the user to enter
base number such as 288E334 but I want the query to return both of the above
numbers if they both are there.  I have tried [Enter Item]&"*" but nothing
returns.  However, if I enter "Like 288E3334*" then ...

I have a situation where I need to eliminate portfolios appearing in a query
because they do not meet certain criteria.  I can produce a query that can
give me the portfolios that I need to exclude but I cannot seem to get the
opposite to work.  

I have a query that sometimes gives me the "Invalid Operation" error
message but sometimes it doesn't.  This query contains LOTS of Right
Joins (because I need to return records that may not have ALL the data
entered into them already).  It uses ODBC pass through queries because

I have a table that holds client registration info in a Access 2003 database.
Some of the client first names contain "", e.g., John"NE" or Mary "DEC" etc.
Does anyone know how I can search for those records that have "" in FirstName
field?

I've created tables queries and reports to generate an invoice, everything is
working perfectly. The one issue I have is that on our projects 10% of the
total invoice is held as retention until the job is 50% complete. I have the
invoice working perfectly, with the 10% so here is ...

I am using Access 2003
I created an Access Db years ago that keeps track of laps used on machines.  
This program is used by at least 15 different employees through out the
Plant.  Every now and then one of the Queries appears not to work properly