I have 6,000 records in Table A with field 1 and field 2. I want the data in
field 1 inserted into field 2 in Table A. I'm assuming I can use either a
append or update query. Am I right? How do I accomplish this? I need specific
instructions.

DBType = Access 2003
Tables = tblType, tblOwners, tblStoreData
tblType has TypeID, TypeName
tblOwners has OwnerID, OwnerName

I have created a query to get data from three different tables, all using the
same primary key. It works fine if all three tables have data attached to
that key, but if at least one of them doesn't then the query comes back
completely empty. What can I do so that it will display ...

This is my first time to this forum.  I am trying to update an Audit table I
have created with a SQL string in VBA.  Here is the code:
   SQL1 = "INSERT INTO tblUserAudit ( EmpName, EmpID ) SELECT qryFetchName.
Name, tblUserNames.EmpID FROM qryFetchName, tblUserNames WHERE ...

Hey All,
How do I create a crosstab query with parameters.  I want the user to type
in a date that will be the start of the seven days for the week following
that date.  So that it will then report jobs and how much time for each on

I have a table that I pain-stakingly created from a word document (long
story, very long).  Now that I have everything situated in the table I need
to break apart some fields.
Example:

I am trying to create a query that will provide the first name, last name,
address, city, and state from a tblVoter table.  The problem that I am
running into is that there are multiple voters living at the same address.
How would I construct a crosstab query (if that is the ...

Good Morning.
I am getting this error trying to export a query result set to Excel.  The
query runs fine itself, but when I export it to Excel, I get the error.
There are over 13,000 rows to export.  I had thought I had read there is a

How can I convert a field which contains upper case letters to normal case.
For example from: "WATFORD HIGH STREET" to: "Watford High Street".  In Excel
there is a simple conversion function called Proper that will convert from
UPPER CASE to Proper Names.

I am trying to use a parameter query to get results between a start and end
date.  The problem is that the date field is stored as a text field, and I
cannot change this.  I added a new field in my query, which translates the
text into a date field, using cdate (ex: Date: ...

TaI need to add a sequence number to a table.  
Most likely this will break normalization rules, BUT that's okay for this
applet.
I am comparing data in two tables.  Matching criteria is (say) 5 fields of

I have a table with test, scan, point, and data fields.
for each test there are many scans and for each scan there are a many
predefined points. (always the same number of points). There is 1 piece of
data for each predefined point in each scan in each test.

Didn't see an appropriate group, so I hope these two will do...
I'm setting up my table relationships is MS Access 2003. Some tables appear
multiple times (ie, "table", "table_1", "table_2"). When I save the
relationships, the diagram looks fine. When I then reopen the relationship

I,m still a novice with Access so this may seem a simple thing, I have a
database which amongst other things tracks Parts for an I.T Break Fix
Company, I want to show a Current Running % For all parts ordered/Returned in
past 30 days, I have a section which shows the running % ...

I think I need a MVP!  I have a linked CSV file which essentially gives me
all the data I need.  I left 2 columns within this csv file  blank (packed
and run order) so that I could use these columns to manipulate the data.  
Meaning I could use Packed which is a yes/no checkbox to ...