My function is:
Amt:=IIF(([Contract] =99999 And [GSTYN] = -1,[Amount]/1.07,[amount]))
The result I need in this function is " If contract # is 99999 and GSTYN =
-1 (yes) then Amount is devided by 1.07 other wise the amount is not devided

I have a table that I am trying to pull data from in where the table has many
fields.  In one field my criteria is:
In (1455,4671,4743,4921,5882,7544,9125)
In another field my criteria is:

I am using the follwing SQL code to have my running total:
SELECT A.Date, A.ID, A.Amounts, A.Type, A.[Account Desc], A.Description,
A.Balance, A.Currency, A.Banks, [balance]+(SELECT Sum(amounts)
 FROM Bankbalancequery

I have 2 tables in Access, one holds Clients Initial Details, the other holds
a record of each time they are contacted, how can i pull the most recent
contact date for each Client?  HELP PLEASE.

I have a scheduled task that runs at night that opens up a database and runs
several append queries that are stored in a macro.
All of these are working fine except on query that is faily large and takes
a little while to run....it never appends overnight. Every morning I have to ...

I have a query that queries our Customer Orders & Shipping tables. This
query returns data for all shipped customer orders. I have a slight
problem however. When our shipping department ships an order, sometimes
they ship it in multiple packages at different times of the day. When

I want to build a report for the finance dept. that shows several accounts,
each with a starting budget with a running balance. One account should look
like this:
Purch# Desc                      Cost    balance

I have a query setup that has [Brakets] around employee name so when you run
the query you get prompted to put in an employee name.
Is there a way to create a drop down so instead or typing in the name you
could just choose a name from the drop down?

First of all I want to say thanks in advance for your help.
Ok, I have a query that pulls information from an ODBC Connection and a field that gets information from an expression.
InPack: Trim("30085455"+[Expr1])
AND

Where can I find and download necessary software or wizard?

i am tring to use a list box on a form to make a cross tab query on the
fly.  I am getting a transform error when i run it.  can anybody tell
me what this means.  My sql is posted below.
Private Sub MakeFilterCriteria_Click()

I have data pulling together costs for travel throughout the year. I
have created a CrossTab query (not my favorite type of query) which
shows the type of travel (row header) and month (column header) with
the total cost at the intersection of each month/trip type. With all 12

How do I set up a form where a value entered into a textbox is the criteria
needed for my parameter query and I click on a command button to run it.
Also, is it possible to run the query to display in a list or text box with
the form open?

I would like to create a query that runs on monthly basis showing the
data in the the following format
January  February  March  April  May ........... Decemeber
Under each Month i want to have

I want to add 6 working days to certain date, excluding weekend and pub.
holidays in Australia calender.
thanks
mamdouh girgis