I've seen similar questions to this but need some help/clarification.
I have Access 2003 with linked tables to a DB2 database. The fields
I am querying are numeric in this format 20070810 (yyyymmdd)
What I am trying to do is display customer request date and

In append query:I have a calculated field that results in a decimal value.
The value is correct until I append to a tabel, then I get a zero.  I have
set the data type for the field to:" number" and properties to: double,
percent, 1 decimal place ( and tried all other sorts of ...

Somehow, I've set some setting in Access 2003 that won't allow me to abandon
an object without saving it. It also has stopped warning me when I update a
table. What's the option?

I have a table with 40 fields and import data into it from another source.
Sometimes there could be 50000 records and at other times there is 500
records.
Is there a way to programatically remove fields from the table that do not

I am trying to eliminate the highest 2 percent of data in a field. The
purpose is two elimiinate items that are unusual to rest of the set of data
and skew the averages. Is there a fuction that will do this? Thanks!

I have 2 tables, stock and transactions. i want to subtract the value antered
on the form from the UnitsInStock value on the stock table.
how do i get the value from the form.
Currently my query reads;

I have a table that contains three columns.
ID1, ID2, and Flag
ID1    ID2    Flag
1234  1234

I am trying to convert an Access 2007 database to SQL. I keep getting the
error "Upsizing wizard cannot run with any database objects open". But it
does not tell me what is open and how to close them. As far as I am aware you
can only run the Wizard with the database open. Is ...

I have two tables with the exact same fields.  The second table has new users
that I am trying to get on the first table without having to enter them one
at a time.  I am an access newb so I am not sure how to go about getting the
records from Table 2 to Table 1 quickly.  Any ...

I am now ready to start validating the data in my database. It's extracted
from several Excel Tables. One problem I'm encountering is that I need a
One-to-Many relationship between "EmpData" (One) and "CurrentData" (Many).
But I've got more records in "EmpData" than in ...

I'm trying to use a Union query with 3 tables to combine the following
fields. Not all customers have a territory or broker; however, I would like
al lthe customers listed in the output. Thanks for any help
Customer Number from table 1

I have a query with a 'date' column.  In this column, I have dates from
7/27/2007 - 8/12/2007.  When I sort the dates, it goes from 7/27 - 8/1.  Then
it goes 8/10 - 8/12, and from 8/2 - 8-9.  What can I do to get this thing to
sort correctly?

I'm using one table in an update query and I want to be able to update items
from one field based on what is found in another field.  It seems like it
should be simple, but everything I have tried as "criteria" hasn't worked.

I have a table, one field has customer #, the other field has sales rep.  Now
in some cases it is possible to have the same customer # more than once with
a different sales rep.  I need to design a query that will pull out all the
Customer #'s that have more than 1 sales rep.  ...

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