Recently the Access OfficeXP PC fails on either local or remote
databases when I run a make-table query, resulting in an Invalid
Argument box which upon clicking says it is a 3001 error. The Select
Query mode works fine however.

I have been using Access 2003 for about 2 months now. Access has been working
fine until now......
My Problem
When I create a query, I add the table that I want to query against and then

I just upgraded from Access XP to Access 2003. I am working with an MDB file
originally created in Access 2000.
I want to change the order of the output columns in an existing query.
In the past, I accomplished this in Design view by dragging the column to

I'm not sure if this is the right place or not... I'm using an Access
database from VB6 via DAO.
I'm doing something like this:
sSQL = "select * from table1 where [column name] = 2"

I have a customer list and a non customer list. These list contain many
duplicates. How can I search for the duplicates in the two files and have the
noncustomers remaining after the duplicate search be added to a new
table/file?

Does Access support "triggers"?  In other words, I want Access to generate a
"report" when a certain date in a certain field is reached.  Or at least
notify me via a text box... or any other way
thanks

I'd like to do a select with a join using three tables, but I can't seem to
do it.  The query I'm trying to do should be something like:
SELECT a.task_id, a.task_start_date, a.task_finish_date, a.task_name,
a.task_pct_comp, a.task_is_summary, b.res_name

I have built an Append Query that will copy records older than 180 days to a
new table called Archive.
I have also built a query that deletes the same records from the current
table.

I have tblSheet1 that has fresh data that I would like to use to append to
tblEmployee.  
tblEmployee has L_NAME, F_NAME, RoomID, Room, and tblEmployee.
tblSheet1 has the same except it doesn't have RoomID.  It only has a Room

I manage a A2K database and am continually asked by management to
produce various reports.  Reports are often complex and require several
queries to be constructed before desired results are produced.
This leads to the cause of my problem.  My query window is building up

I want to delete the first three characters in the string
thank you

I ams truggling with a query and was hoping someone could point me in the
right direction.
SELECT tblTimeCard.EmployeeID, tblTimeCard.TimeCardID,
tblTimeCardHours.WorkCodeID, tblTimeCardHours.Hours,

I need your help... I have five people working on the database and we have
many different queries.  When two people run two different queries, it get
error message "workstation locked by Admin".   How do I solved this avoiding
getting the error message...?

how come i randomly get an error message saying table not found (exact error
message is pasted at bottom of this post).  I get this error when trying to
perform a select statment with ADO in visual basic 6 on windows xp to a
remote access 97 .mdb via oledb.

I need a query to move a decimal point to the left 2 spaces. I have a
database created by another company and in the cost field they are not using
a decimal place. $2.59 in there database looks like this 259 without any
decimals. How can I fix this problem?