I have some questions on calculations,IIF,etc.

  • Thread starter Thread starter Asif Ismail via AccessMonster.com
  • Start date Start date
A

Asif Ismail via AccessMonster.com

Hey, hi....
I've got to submit my report as soon as possible in school and help would
be greatly appreciated. I've stayed in a troubled state from quite a while
and I think you will heal me.
Now, first - Calculations.
I want to find the sum of two fields - Book Fine, For Other Penalties: .
I want you to help me, tellign me how to do it in Queries and Forms -or any
one of them. In Queries, I create a new field -and type:-
total:Bookfine+ForOtherPenalties: ,and click on View DataSheetView. A
message comes up asking me to enter Parameter value for each of them. Now -
first of all I dont understand what all that means -and what should I type.

For IIF,
I went to Queries and typed the formula besides Age field. Age:IIF([Age>10]
,"Mature","Immature"). I then clicked on Datasheet View and the same Enter
Parameer Value appeared. What the hell is that and what should I type in it.
Thirdly, How to perform Interacting Query.
 
I want to find the sum of two fields - Book Fine, For Other Penalties: .
I want you to help me, tellign me how to do it in Queries and Forms -or
any
one of them. In Queries, I create a new field -and type:-
total:Bookfine+ForOtherPenalties: ,and click on View DataSheetView. A
message comes up asking me to enter Parameter value for each of them.
Now -
first of all I dont understand what all that means -and what should I
type.
Click to expand...

You may have a typo in your calculation. Make sure that the field names in
the calculations are spelled exactly the same way they are in the field
list. If you have spaces in the field names, then be sure to put square
brackets around them -- [Book Fine] + [For Other Penalties].
I went to Queries and typed the formula besides Age field.
Age:IIF([Age>10]
,"Mature","Immature"). I then clicked on Datasheet View and the same Enter
Parameer Value appeared.
Click to expand...

It looks like you have a syntax error. Try [Age] > 10.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
 
They keep on saying I have a syntax error of comma, or if not that -
then:Enter Parameter Value. And the way you typed in -I typed in the same
manner too. Dont know what's the problem. Can you tell me what to type
within the Enter the Parameter Value?
 
Back
Top