I am tring to get a value to calculate in a report.
I have all the data from a tabel and i want to DLookUp one value to calculate from a tabel called Employees. I can get the value to lookup fine. It is a Yes/No value. I get the -1 for yes just fine.
I want to make it check this value and multiply it by a value all ready on the report to make a new number. (These are all dollar values)
I kinda need a if then statement. I just don't know how to write one in the Expression Builder? I am new to Access and just self tought.
Hope someone can help.
Here is what i have so far.
I need to check the RBOYesNo Feild for a -1
I have this feild doing a DLookup (works fine)
if it is yes(-1) i need it to take a percentage of the total (RBOAM) is a percentage
if it is 0 i need it to just do nothing.
I have tried everything i could think of. Nothing will work i just get Syntax errors.