Ok, I made some time.
In my DailyTask Table I created a Markup Field.
Here the expression I tried:
IIf([TDATE]>=12/1/2011,[ProjectID]*1.1,[ProjectID]*[.7%])
I didn't know what to put in the "markup" brackets?
Ok, I made some time.
In my DailyTask Table I created a Markup Field.
Here the expression I tried:
IIf([TDATE]>=12/1/2011,[ProjectID]*1.1,[ProjectID]*[.7%])
I didn't know what to put in the "markup" brackets?
Bob:I agree with your reply, thanks for the correction and link.
I tried:
=iif([TDATE]>=*#*12/1/2011*#*,[ProjectID]*1.10,[ProjectID]*[markup%])
"You may have entered a comma without a proceeding value or identifier"
I'm a little ready to scream ...
Did I have quotes around the # when I posted what I posted? NO I DIDN'T! So why did you add them? WHY???????