I know I have seen this before but I just cant seem to find the one web page with this on it. My question is ...
How do you reference user defined field names, like MyField: blahblah in the design grid. I want to reference the MyField in the Criteria section of another field. [MyField] acts like I want to enter a parameter. I thougt it was some special symbol, but I cant remember it.
Nope. Let me put down another way. I have a calculated field i the design grid say
InvCost : [field1]+[field2]
and I have another field
Now I want to make sure that ActCost is Less than InvCost. If I put <[InvCost] in the CRITERIA section of ActCost is prompts me like it is looking for parameter. Not what I want. I want it to reference my ALIAS of InvCost and do the expression. Thanks
Field ComPrc: Val(Mid$([PoItemMsgTxt],[STRPOS],7))
Field CstDff: [RevItemListCost]-[RevNetInvoice]
Criteria Here is where I want to reference ComPrc, but <[ComPrc] does not work. I thought there was some other way to reference a user field with some other special character not with the brackets
Maybe it is because I use the user definded field name [STRPOS] in the first field and Access cant keep track of it at the second level