Have searched the groups on the topic, found Nz, but can't get it to work. I
probably have the expression in the wrong place in my query. It's in the
Value column.
Here's the SQL for Nz in the Value column :

Missing: Count(IIf([charges]=0 Or [FinancialCode]is not 222 Or
[FinancialCode]is not 333 Or [FinancialCode]is not 555,1,0))
This formula tells me that is not only works with null.  My goal is to have
all accounts that have 0 charges that are not with financial code 222,333, or

I am trying to execute a switch statement that looks at the last 3 letters in
a trader's portfolio, [port].  Can I use a "like" in the statement?  Also, I
want 2 portfolios to yield "DPM" (EMS and MOD), can I use an or statement?  
How else can I get this to work?

will dcount work
2 tables
First has Aircraft with Start and Stop values and unique event ID
AircraftID       StratHours     End Hours   Event

like union i need intersect which give me the comman records from two table
i have two table having comman field but the number of record is different
and may have different in number then i need the comman record in table one
on the basis of second table

Can anyone help please? Report Gross Grand Total and Sales tax Total are off
by a penny or 2
The amounts are being generated by the
sum expression below that calculate unitprice and salestax so users only

I need to search for the last name of client and last name of spouse, two
seperate fields. I'd like to be able to ask for the last name once and have
both fileds search and return those records. Is ts thjis possible?
Thanks

I have merged a table of "lapsed customers" with a table of "all customers"
where just lapsed show with all the customer info, such as emails. There are
many contacts at one company. But what I need to find is only the companies
that have no contacts.  Here's the dilemna sample

I have a table where some users entered tab characters in a particular column
and I have to find them and delete them. How to find them? Can I use CHR$
function?

I am trying to run the following query from OleDbCommand object but
getting an exception.
UPDATE [Files] SET FilePath = REPLACE(FilePath, 'd:\\', 'c:\\')
Exception is:

I have the following expression in my query:                                  
               Expr2: IIf([SCHW ADV NETWORK - New]="Yes",[TOTAL FEE]-0)
"SCHW ADV NETWORK - New" can now either be "Yes" or "Yes - New", how do I
add this?

I have some sales data and in the quantity sold filed the qty of the item
sold is combined with its unit of measure.  For eample; 5 ea, 10,000 PAC, 125
EA, 2,345 PCS.  This is a text field and after each number is a space before
the unit of measure.  How do I get a query to just ...

Please help I am new to Access.
I get a Aggregate Funcition error from Trvl_Start when I try to run this
where am I going wrong?
SELECT Sum([ACT_TRVL]) AS Total, tblAttendan.TRVL_START

Gross Order Total and Sales tax Total in Main report are off by a couple
cents.
----Order Details Table----
OrderDetailID - Primary Key - AutoNumber - Long Integer

I am building an expression where I add the first 4 months of sales so that
it is contained in one column. However, when I run the query I receive all
the 4 months of numbers in one cell instead of in total. For example, I'll
get 4.352.10 instead of 6.45. Here is my SQL Code: