I am using Access 2003
I created a Db for Machine Mtce.  The table consists of 3 tables, (1) Basic
Mach Infor (ie Mach#, Mach Name, Mfg etc) - (2) Operations Table - consists
of different prev mtce (PM) that need to be completed at various time frames.

I have a database of company phone numbers and their terminating points.  I
want to take a primary number and find what other numbers route to that same
terminating point.
EX. 800-800-8008 routes to office ABC skill 1111,  I want to know what other

I have a table that has the complete name for each user.
I would like to run a query to match the FirstName LastName with the
CurrentUser() and return a user_code.
This is the query that im using now:

// reposted: to straighten table data //
I am attempting to use Duane Hookom’s concatenate function without any
success.  I’ve read many threads, relating to Duane’s function, yet none seem
to fit my situation.

I have 2 Tables.
One has a list of our part numbers and the other is from our supplier.
The difference in the part numbers is that they have started to put a 56 in
front of them and we have not changed all of our numbers over.

Say I have a table named table1 with the following fields (for simplicity)
ID - autonumber
field1 - text
I have a form that allows the user to enter a value in for field1 and checks

I'm trying to execute the delete query below, but Access keeps giving me an
error that it "Could not delete from specified tables". It looks as though it
might have something to do with the write access, but I know I've opened up
the database for both read/write access. I've ...

hello i have the following code in a query
[forms]![FORM2]!Between [datein] And [datein2]
i am tryng to perform a date range find using the two fields on form2
[datein] and [datein2] but to no avail any ideas!

I have three fields in my table: Date1, Month1, Year1
The data is as show in the Date1 field:
01/01/2007
01/11/2007

I have a query (full SQL below) that's used in a procedure which promotes
records through a sequence of "gates" involved in a material handling
process.  Sometimes, a promotion can bypass gates, e.g., item(s) can move
from gate 2 directly to gate 5.  This query looks through a ...

I have following criteria for my query.
I wanted different date range if it is Friday or not.
IIf(Weekday(Date())=6,Between Day(Date()) And Day(Date()+2),Between
Day(Date()) And Day(Date()+1))

I have a 12 page newsletter I am trying to transfer from Word to Publisher. I
print it on our Xerox machine that is on a ip internet network. I've been
printing it in word on tabloid paper, double sided and it comes out just
fine. When I use the exact same settings in Publisher, ...

I'm having trouble getting this to work:
delete A.* from A  where  exists(select * from A, B
where a.empno = b.a_empno and a.paycode = b.a_paycode and a.hours1 =
b.a_hours1 and a.date1 = b.a_date1 and a.pos = b.a_pos);

I'm trying  to find the differences between two tables, A and B.  There are
some records in A that are not in B, there are some in B that are not in A,
and there are some in both but with differences in the fields.  I'm not
getting everything. Does anyone have any ideas how I can ...

       I have a Query which filters out certain records from an existing
Table, how can I copy these filtered out records which were based on certain
criteria, to an existing Table which have exactly the same name of fields as
the Query?