I have the following calculated field in my query design grid:
ProjectCheck: [STProjTask]<>[CorrectProjTask]
STProjTask and CorrectProjTask are also calculated fields, therefore ProjectCheck is a calculated field that references two calculated fields. All of these calculated fields are defined in this one query.
When I return to Datasheet View, I am prompted for a parameter query on STProjTask. It's as if Access doesn't recognize STProjTask. STProjTask is spelled the same when I defined it as a calculated field and when I reference it. So I don't know why I'm being prompted for a parameter input.
I am thinking that Access may not allow calculated fields to reference other calculated fields?