I'm trying to run a query that pulls in records without certain states
(approx. 20 of them) anywhere in a field's text.  I set up the criteria as
<>"*Maine*"and<>"*New Hampshire*"and<>"*Rhode Island*"
This is still returning records with the states in them - for example "EC

I use Between [Date1] And [Date2] in my query. It works fine. The users will
enter the dates in the message boxes. Is there a way to insert the calendar
on these message boxes so they can click on the calendar instead of entering?
Form? or Report?

Well here I go again. Biting off more than my brain can handle. I have a
report that shows all of our machines in our plant. I’m tracking both machine
down time (the time the machine is broken) and Plant Down Time (the time the
machine is broken that hampers production) I have a ...

I have a question that I hope I can phrase simply.
I have started to record all the compliments that my company receives. Now
some of these compliments arrived in 2006 and some arrived in 2007. One of my
fields is called Compliment Number, and, as you've guessed this is an

What I'm asking for here would be so easy in Excel but my skill in Access
just doesn't cut it yet.
I have 2 tables, first table (Table1) only contain one field (a list of
dates, starting from "2005-01-01" and ending "2007-10-31"). The second table

I tried to make a  query selecting data, one of the conditions turns
on the Date. My 'Date' field consists of a consecutive number of dates
except Week-end days.
When I use the criterium:

  I would like to output some of my tables to different worksheets
within the same excel file. does anyone know how I can do this from
access. Thanks Sam...

This may sound a little a confusing, but here goes...
I have a query that is run against a database using an ODBC link.
The table in question has a field called CREATED_DATE_TIME and is in the
format DD/MM/YYYY HH:MM:SS

I have a delete query (DELETE tblImportStaging.* FROM tblImportStaging;) that
neither deletes the data from the subject table, nor displays any error
message when I right-click on the query and choose Open, or hit RUN when in
Design View.  (The subject table IS in the current ...

Is there away to delete the sub totals in a pivot table?  I only want to see
the grand total.

I have a problem doing an outer join between two tables.  They are regular
access tables.  I have read through all the questions and answers for the
topic and tried various things but still it will not work.
Table 1 has 205 records.  I want to join with table 2 on an ID field.  I ...

Can anyone explain why some of my queries don't allow me to 'Export' - with
the actual 'Export' item on the File menu greyed out.
This is proving very problematic as I also can't 'Analyse with Excel' via
the 'Tools' menu as I receive the following prompt: 'There are too many rows

I am working on a very old database where the area code was not included with
the telephone number as all of the area codes were the same. I recently had
to add the (  ) to accommodate a new area code.
What I would like to do is include the area code 401 to all of the phone

I have a series of queries that work properly inside Access.  But for some
reason or another, they don't want to work with the Data Access Pages.  Here
is what the queries look like, in sequence:
Query1

When creating a make table query, is it possible to add a parameter value to
the naming syntax in the make table name?
Thanks