I am looking to combine two tables.  Both tables have one column with the
same name but all the other columns are different.  The column with the same
name, "Tags", may have the same row value in both tables, but there are
different values also.  I am looking to add both tables - ...

Can someone please help, this is driving me nuts
I have 2 querys with the following fields
"Work Orders Query"
[Work Order ID], [Date], [MaterialSubTotal]

I have a table of actual dollars spent with project numbers and categories.  
Some of the categories are incorrect.  For example... Project 1 has a
category of Growth and should be Non-Growth.
I have several projects (1530 to be exact) that I need to update the

I'd like to convert text to int to retrieve bad records.  The records
are basically Last, First, ID, Img#.  All Img# will be either a real
number, or a text field like 1411/1412 or 1411-1415.  I'd like to
retrieve all records that have either no img# or a img number like the 2

I would like to show in a query the time formatted to look like:
HH:MM A or P
In other words I want to show hours and minutes followed by an A if it's AM
or a P if it's PM.  Can anyone help?  Thanks in advance.

Working in a large workfile with worksheets that are linked. Formulas were
calcing fine and today stopped auto calcing and only cal when pressing F9
over and over and over.................

Access 2000.  I have table of many hundreds of records.  One of th fields of
text looks like this: XXXXXXXXXXXX and I want it to look like this:  XXX XXX
XXX XXX by adding the spaces.  Would someone please show me how to write the
function or code to add the spaces to the text as ...

I have information from a query that i need to sum in a report, this is what
the query returns
7A0001    2
7A0004    3

There are several fields stored in a field for guest information that I need
to format.  Specifically, Zip Code and Phone Number.
Both fields are stored as text, and without any symbols.  For example,
someone with a zip code of 12345-1234 is stored as "123451234".  Another

I have a make-table query which consists of all the fields of an existing
table plus an additional 10 columns.  Each of the additional 10 columns has
a custom defined minimum function.  The function works fine, except in the
table that gets produced everything is in text format.  ...

I have set up a form which includes an input mask on a date which concludes
with it in the following format "Month Year".  I now wish to run a parameter
query which brings back all records which match a particular "Month Year".  
Unfortunately it will only bring back any items ...

I have an access database (2k) that imports data on an hourly basis from a
Dbase application.  When i run each of the import/append queries seperately,
there's no problem - everything bahaves itself.  Where the problem arises is
when I use my macro to run the queries - at one ...

my computer turns on but the screen ,keyboard and mouse doun't come on,
 I have tryed them on another computer and they work fine.
so please help

I'm trying to pull the max values within a certain field, but I need to keep
the max values with the respective values in another table. I've got a device
name table and an analog table. within the device name, i'm pulling
everything with * kW and trying to find the max values ...

I'm creating a table with the help of a make-table query.One of the fields in
the table REP_ID needs to have a start value of 1000 and should be
incremented automatically by 1 for every next record.
I tried changing the type to AutoNumber but thst does not work.