Prompt asking for date or "too complicated" error

[Gina Maylone]

Good morning!



I am using the following in a query. It prompts me to enter the date, if I do, I get data, if I don't I get the "expression is too complicated" error.

AsmtNote: IIf([trimmedasmt]="roads",Format(DateSerial(Year([forms]![runsassessments]![daterun]),Month([Forms]![runassessments]![DateRun])+4,1),"yyyy ") & ([trimmedasmt] & "Asmt" & " Lot" & " " & [lotnumber_fk]),Format(DateSerial(Year([Forms]![runassessments]![DateRun]),Month([Forms]![runassessments]![DateRun])+2,1),"mmm yyyy ") & ([trimmedasmt] & "Asmt" & " Lot" & " " & [lotnumber_fk])).

When I get data it is correct: Apr 2019 Monthly Asmt Lot 0373

I cannot see where there is a problem with the statement, can any of you? Or is there somewhere else I should be looking? The RunAssessments form is open with the date run entered. TIA!

[pbaldy]

This is flagged as solved; is it? If not, what exactly is the prompt? That will tell you what it can't find.

[Gina Maylone]

This is flagged as solved; is it? If not, what exactly is the prompt? That will tell you what it can't find.

Yes, I solved it, rewrote it without the extra space! AHHHH! Sometimes I can be such an amateur. :-) Have a good one Paul!

[pbaldy]

Great! Have a good rest of the weekend.