i am having trouble with getting the statement to work like i need:
IIf([REFUND_LETTERS_ALL_COUNT].Counter=1,"First Request","Second Request ")
AS Expr1
What I need to do is nest this statement so that the result will show

I don't know how to go about this and would really appreciate help on it.  I
have a table with the following fields:
Territory
DateRecd

I need to create a query that will do the following:
these are my fields: resign date, hire date
I need to subtract the resign date from hire date but I want it to return
the answer as years, months & days

 I am trying to add 1 record to a table using an append query...  but it
does not stop at one record...  here is the code...
strSQL = "INSERT INTO tblSOS ( SOSDate ) SELECT " & Format(Me.txtMealDate,
STRING_DATE) & " FROM tblSOS;"

I have a field in query:  New_Cost: [AllocatedCost]+[MonthlyCost].  I want a
new field called Cost_Percentage which needs to Sum the column [New_Cost] and
divide by each record [New_Cost] to get that percentage.  Can this be done
with DSum and if so, how?

I need help with T-SQL syntax.  I need all products ordered together.
This would give me all products in an order.  I don't want the orders
with only one product.
SELECT o.orderID, o.orderNum, ol.productName

i'm setting up a table which has categories and subcategories. I want to do
both with lookup listboxes in two seperate fields. I created another table
with category and one of its subcategories for a two field table. There are
records for all categories and their subcategories. I ...

What does it mean when you run a query and do not get results?  However, if I
create a new query it runs.   I have had this db for awhile.  Recently I had
to replace data in the main table.  Checked all fields are there but when I
try to run queries it is not generating any data. ...

I am working on an existing database. I want to create a query which
pulls data from 2 child records of a parent. The first record in my
query would contain information frmo the first child record along with
the first child record of the other table, the second to the second,

I have a table which looks like the following:
PLU    ITEM    DATE    SOLD
12345    BALL    3/7/08    6
56789    ROPE    3/7/08    8

I'm having trouble getting an Iif Statement that includes a Dlookup to work.  
Here is what I have but the records where the Iif is true show nothing for
this field.  
IIf([tblOrders].[FreightOnly]=False,[tblOrders].[Price]-DLookUp("Price","tblProductCost","EffectiveDate

Dears
While we making a query by using query wizard' there is a option to get
sum,min ,max,avg in summary option if the data is in number type.
Any body can sujest any logic to get max and min value if the data type is

Hi Group,
Would appreciate if someone could help me with a complicated if
statement.
Here the set up...(I manage as awards database for applicants)

I have 12 columns representing 12 months usage. I wanted to create a 13
column and use the AVG function.
AVG_SOLD: AVG([QTY_SOLD_P1]+[QTY_SOLD_P2]+[QTY_SOLD_P3]+[QTY_SOLD_P4]+
[QTY_SOLD_P5]+[QTY_SOLD_P6]+[QTY_USED_P7]+[QTY_USED_P8]+[QTY_USED_P9]+

Could someone assist with the following? I am getting errors!
Sum(IIf([Award Date]) >= ([Date Rcvd]), ([Award Date])-([Date Rcvd])) AS [#
Days to Award]
Thanks,