how to write this criteria....? Please Help

[yhchen]

I am writing a database to record staff training records

each training record will have two costs involved: cost of the course and no show cost

I would like to write a query which if attendance is set to yes, then the record would show the actual cost

if the attendance is set to NO, then the query would show the No Show Cost

anyone knows how I can acheieve this?

 

[KenHigg]

Add a column and do something like:

Final Cost: iif("[attended]","[MyActualCost]","[MyNoShowCost]")

Where the names in the brackets are your field names.

 

[yhchen]

Add a column and do something like:

Final Cost: iif("[attended]","[MyActualCost]","[MyNoShowCost]")

Where the names in the brackets are your field names.

Thanks KenHigg...

Is this a column in a report you are talking about??

 

[KenHigg]

Do it in there query that the report is based on. Place it in the top row where you would normally put the field name.

 

[yhchen]

Like this??

but it resulted like this....

 

[raskew]

Hi -

Try removing the quotes:

iif("[attended]","[MyActualCost]","[MyNoShowCost]")

Bob

 

[KenHigg]

Hi -

Try removing the quotes:



Bob

Sorry about that...

Good thing its Friday

 

[yhchen]

Thanks a lot folks!

It works!!

Have a nice weekend!!

 

[KenHigg]

Glad you have it working -