Geeze, I wonder if that makes any sense.
I have a table with a list of 1800 stores and store information.  Some of
the records have missing information.  So I left joined the table on itself
with the criteria or'ed for all fields I would like to test. SQL is below.

I know access does not have them but I've read of SQL programming that
allows for updates and deletes, appends, ect in SELECT statements.
Could someone post an example of this, doesn't matter what it is, I
need a point of reference (a link to an online tutorial would be great)

I need to create a query that pulls up a Part Number from the Part table only
if there are no PRs in the PR table.
tblParts.PartNo
tblLinkPartAndPRs

I would like to substitute a month's name for its numeric equivalent in a
query.  The date field ([ArrivalDate]) contains dates like 3/4/1855 and
12/31/1843.  I want my results to look like:  March 4, 1855  or December 31,
1843.

What is the difference?
Does "DbEngine(0)(0)" not return a database object, just as CurrentDb does?
I have run an action query with:
DbEngine(0)(0).Execute AppendSQL

How do I call a saved append query from VBA module.  I tried using
docmd.runsql() and hand typing in the code but I am getting error. The saved
query in the database (qryPreImport)works fine.
Here is the code in the module with the SQL hard coded, which fails.  Error

How can a make a calculation in a form object update automatically when data
used in the calculation changes. All data is with he same record.
This has to be simple, but darned if I can figure out how to do it.
thanks

This one has me stumped. My question is, basically: "For the two
departments in question, list all employees who (a) got paid on
11/27/2006, and (b) had one of two particular deductions on that
paycheck."  I replaced names of actual tables with more readable ones.

The query below selects the records existing in Table A which have no
matches in Table B.  I use this query every month without problem.  This
month however when I run the query get the following error mesage: "Invalid
Operation".  I checked in the Help button of the error ...

Is there any SIMPLE way for a query to subtract the values of one record from
another? Can the value be calculated in a field in the query. Such as
Difference 1, Difference 2, etc?
I want to take the latest 2 dates and subtract the less recent from the more

Dear Access2000 group,
My Table_Volunteers has 70 fields.
My query_A displays all 70 fields (from table_Volunteers) plus
an additional 17 calculated fields for a total of 77 fields.

I want to eliminate serval types of data. For instance I do not want to show,
D,S,V, DV, M, 1, X. I keep getting an error that the string is too long.

I have the following situation, I have a linked MySQL table which is
populated, and a blank Access table whose schema matches the MySQL
table as closely as possible.  I'm trying to write a query to copy the
data from MySQL table to Access.  I know that there is no problem with

I'm designing a database so i can keep track of queries at work...
I have designed it but I want queries that are over two days old to be
escalated
there is a form where i fill out the query, and a subform which stores

I have a Microsoft Access 2000 database that I converted the back-end
to SQL server 2005 and kept the front-end same. Is there any way I can
hide the pop up screen for SQL Server connection so that the users
don't have to enter userid and password when they try to run a