There's a space in the second spelling of HIST_MIS_CDS!TYPGESS. And , "Yes, I've made the same simple mistake, myself"
If I'm reading it right, you check to see if the field is blank before comparing it to the other field. If it's blank you don't do anything to it, so I think you might be able to skip that part of the expression and just test it against the other field, making the expression that much simpler. I'm not saying that there isn't a valid reason to do this, but I don't see it here.
No, the name of the textbox is CA_MOVE. I have the query in the ControlSource of the textbox. The Form's RecordSource is a table. However, since it is an attached table, I cannot add a calculated column to it.
Trowe, I tried the simpler query, but got the same error. It looks like it cannot find the fields I am referencing, although I selected the field anmes from the Expression Builder itself, so there is no typo.
Dont mind asking, Can you tell me what exactly are you tring to use this report for? (what do you expect this to do? Because if is not producing what you are expecting, I did have similiarly the same problem sometimes ago and I think I may have a demo report of the same kind which I would send if that is what you are looking for and if I manage to find that.
Thanks, but I figured it out. The REPORT_CLIENT is attached to an Oracle table of the same name and I am now using a PL/SQL UPDATE statement to write results to the Oracle table and simply open the Access table.