I have an IIF query that currently looks like this:
GlobalType: IIf([SuperCircuit_IDs].[Type] Is Not
Null,[SuperCircuit_IDs].[Type],[Customers].[Type])
I need to add one more argument.  I have another query named "Affiliate"

I have a database containing info about response times to user
requests. In addition to the response time, each record contains date
when the request was made. Now I need to count two averages for each
month: average for top 90% of the response times (ordered by response

I have a table called Agents with these fields:
ID (autonumbered)
Name (text)
Referred By (number)

I want to have a query that returns the records where the values from Field1
or Field2 of a table named “Items” are equal to the value given by a Combo
Box (“cboSelectValue”).
So I’ve made the SQL statement.

I have a table and I am trying to get a query to create a value.  sanfu
showed me how to get it to work with a sum funciton, but I am curious if I
can get the query to create a field with a date, based on a date equation.
I am trying to put the following in design mode of a query ...

How to put an address on two lines in a query?

I am in a pickle, we made some changes to our db, most of them fixes to
forms and reports, but I did add/delete some idexes. But all the sudden one
form we have, which allowed the user to edit changed to non-updatable. The
only change I can see that would effect this is the ...

How can I change this expression to add 0 to any null values?
soflinesum: Sum([qty]*[price])
TIA
Les