I thought maybe I should give more detail to my earlier question. I set up a
simple query using fields from three tables - customer, orders, order
details.  My objective is to pull a list of all orders that have not shipped
yet.  So, I set the ship date to null or "" and sorted ...

I appear to be encountering length limit problems on a few SQL filters.  
Following is an example.  Any assist or workaround would be appreciated.  I
tried using the wildcard around an individuals name and it does not work.
Sample Filter:

Hi Everyone - need some help and you guys are ALWAYS coming to my rescue!!!
OK - i have a query with an Expression that right now is as follows:
Expr1: IIf([CurrentWeek]![Original_SVS_ID]="UNDELIVERABLE,
[Exp","Undeliverable - " &

Has anyone sent email to contacts in a table in Access without using a third
party add-on?

I would like to create a query for my employee database that tells me if any
of the following fields are expired -
 auto insurance
 drivers license

Access 2002, distributed an MDE and ran under Access Runtime 2002.
I have a query that I call to fill a list box. The form has textboxes and
combo boxes that the users changes to filter the list box. From the controls
I query the query to fill the list box.

I have an option group on a main form with four choices (radio
buttons). I also have a txt field that takes the corresponding value
from the option group, depending on which radio button is selected.
Last but not least, I have a subform on this main form, which has a

I have a  table like this:
ProvID   Type          Office
1        Rad-H         Office1
1        Rad-A         Office2

I am trying to run a query with a DSUM function to sum quantities in
one field based off the value of another field. I have an inventory
quantity that I would like to sum based on part numbers but I am having
trouble with the criteria. It should look something like this:

I have a table that has several fields, not all of which are used for
each record.  I am looking to export a query on the table, but I only
want to export if the field is populated.  Another words one record may
have information in Field1 and Field2, but another record has

I recently have some problems with making a proper query.
I have a few linked excel keeping track of hours worked per day.  The excel
sheet are being organized weekly such as 1/1/06.  For the whole week, the
date for monday until sunday will still be 1/1/06 (the following week ...

It is possible to write a select statement that will give me the median of
some values when my data looks like this:
UserA  10
UserA  20

Hello Every body,
I have an requirement where  i  have an employee table  with their
managers reported.
Let me give you structure of the employee table

i need to make a query that calculates if an employee is past a 1 year
probation.  i have an employee starting date field, and need to compare the
field to todays date.  if the answer is past 365 days, the record is ignored.
if less then 365 days, the record goes to a report.  i ...

In my query, I need to select records where the field (OPL_Type) is not 1 or
2.  In the criteria row I typed Not ("1" Or "2").  
I ran and saved the query.  It looked good.  
I went back into the query and the criteria was missing from the OPL_Type,