Hi again,
I have a situation that may call for either a multiple nested IIF, or
a Switch(), or a DateDiff, something else I haven't even heard of.
Basically, I need to get the number of days during a given month that

I have the following expression:
Expr1: IIf([SCHW ADV NETWORK New]="Yes",[TOTAL FEE]*0.15,IIf([SCH ADV
NETWORK New]="Yes New",[SAN FEE],IIf([SCH ADV NETWORK New]="No",0)))
The first part of the expression works when SCHW ADV NETWORK New equals

hey everyone, i know it is a silly question but i am missing the most
critical part about it...
i have two tables "newest" and "removed". they both have two fields: Code
and Name. i want to compare the data in the Name field and get the common

If someone could help me... i'm not very good at queries...
I have a table with say 10 different columns, but i'm interested in just 2...
Column 1 is a "policy number" which can have entries that are the same
Column 2 is a "post code/zip code" which can also have entries that are ...

I have a query in my database which includes the following fields from
various tables:
orderID
stockID

I have the following query:
SELECT tblAMUWork.AMUWrkID, tblAMUWork.DateRcd, tblAMUWork.TypeOfWork,
tblAMUWork.MISNumber, tblAMUWork.RptName, tblAMUWork.AmtRcd,
Nz([CompletedAmt],0)+Nz([CompletedAmt1],0)+Nz([CompletedAmt2],0)+Nz([CompletedAmt3],0)

I have a query based on 2 tables = [stafs] and [x confirmed].
Essentially, [staffs] contains standing data (like staff names, hourly rates
etc) and [x confirmed] contains monthly data - this is added to every month.
Some of the monthly data is in fact just a record of the standing ...

I'm not sure how I would set the sort criteria for this situation; any help
you can give me is appreciated.
My contract numbers in my table are always 13 characters in the following
format: NNNNNNNNN-NNN-N.  I want to sort based on the numbers in spaces 9,

I need to use an expression in query to change the color of the result
according to status.
Example: if the date of manufacture exceeds 60 days form today ... the
number that appear changes to RED ... if not then BLUE.

I have a table with times recorded for various events for each record. Some
are null. I am trying to create a query to select the latest time. An 'iif'
statement would be extremely long and complicated by the null values. Any
suggestions?

I have several tables that store data captured on a single form (and
subforms).  Basically, it is a form that I use to record activities.  The
form has a subform that captures the names of the people involved.
I am trying to create a query that will identify all of the activities ...

I am trying to create a query that updates several tables based on a single
user input. First, the user is going to import different sets of data into
different tables. Then, he/she is going to run a query that updates all the
blank DATE fields in all the tables with an entered ...

I may have asked this question last week, but I can't find my post and I
don't have anything in my notes, which I normally take, so I apologize if
this is a second posting.
I need to create a query to combine multiple records in a table that have

I have a combo box that when clicked provided a list of names (duplicates too
which is another issue). When clicked an after update macro prompts to open a
new form based on a new query with the
following:[forms]![Violation]![combo16], but the value doesn't get

I create an order status table for my division each week by running queries
on corporate's systems. The field names are always the same, and there lies
my problem. I need to measure the change in promise dates weekly to the order
line level. For example, I need to pull last ...