I'm looking for the text for inserting multiple IIF statements into a query
I have. I currently have:
IIf([Province]="4",([TuitionFee]*0.08),IIf([Province]="7",[TuitionFee]*0.08,"0"))
I don't get error an when i enter the statment but my records that do not

If I have a table with some "yes" "no" data and I want a query to count the
number of yesses and noes, can you please tell me step by step how i could
create this?

I got a very funny situation here.I've calculated SUM  for the following
fields: ([200407]+[200408]+[200409]+[200410]+[200411]) each of these date
fields have got numeric values.I then  summed each field (i.e 200407)  on the
"Totals" row.

I am trying to return the current date.
Using VBA, in an event procedure I have:
MsgBox (Date), I have tried entering Date() but it reverts back to text
shown. When the code is executed I get an error that the "date field" can

I want to perform a query on a database table with a 1:1 relationship. Given
the returned value of the query I want to create a new calculated field that
assings a letter rating (A-D) based on data ranges. eg
       score <= 05 then [newfield] = "A"

5 records have a number field:
recordA = 10000
recordB = 500
recordC = 25000

Is it not possible in Access97? I've tried the following ways to execute
queries:
docmd.openquery thisquery
dbengine(0)(0).execute thisquery

Hope someone can help with this [hopefully very easy]
I have a table that contains various information:
Name       School     Job      Hours
smith

I have a form that pulls it's info from a query. This query tracks stock
symbols and their 52 week high.
the table will have multiple instances of the same symbol. I only want to
see, on my form, the symbol with the last date

I am want to create a cross tab query which will output the data for only
three months starting from the current month. I would want these months to be
headings of the report/query. However, I don't want to create reports over
and over again. I want something, that will resolve ...

I would like to run an Append query automatically each time a new record in
inserted in TabelA. The Append query is designed to insert the newly inserted
records in TableA to TableB without using VB scripts.
What do I need to do so the Append query is run each time TableA has a ...

I have a database that includes the following fields
Category                    Name
PC                             John brown
Monitor                      Joe Blow

I have an Access 2003 Database (NOT a project - ADP). The tables are linked
to SQL Server using ODBC.
My question is this:
Is there a way to call a SQL Server Stored Procedure as the RecordSource for

I am trying to update about 4000 rows where 2 more days would need to be
added to the current dates. e.g.
1/1/2002 will need to be changed to 1/3/2002
5/1/2005 will need to be changed to 5/3/2005

I need to run a query and supply it with an ID (autonum key) which will vary
each time the query is run and may come from any number of forms. Is there
any way to create a query which takes a parameter? My Access book (with 1612
pages) does not mention it.