Link to home
Start Free TrialLog in
Avatar of tamckee
tamckee

asked on

Weighted Report in Access DB

I have inherited an Access DB with one table and multiple fields that are Yes/No fields, For example:

FName
LName
Field 1 -20 is Yes/No

I have been asked to create a report that provides based on if certain fields 1-20 are checked.  If Field 1 is checked, then it should 1.25, if anything else is checked it is .25.  

Short of multiple "If" statements I'm not sure if this is feasible in access
Avatar of Rgonzo1971
Rgonzo1971

Hi,

pls try something like this
Iif(Field1 = True, 1.25, Iif((Field2+...+Field20),0.25,0))

Open in new window

Regards
ASKER CERTIFIED SOLUTION
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial