I have a big query with many fields that several reports are based on. A bunch of reports work fine. I have a new report where some of the fields in the query wind up giving me #Error instead of the value that is in the query. By testing I discovered some fields don't like when I use =[fieldname]. In formulas, I need to use the bracketts. The field is okay if I just use fieldname (without bracketts). Some fields let me use =[fieldname].
I've been able to fix some of the problems by creating a new field (with a new name) in the query which is the same as the original field (that gives me an error on the report). That was okay for a couple fields (though I have no idea what the problem is and why that would fix it), but it looks like I'll need to do this for more fields. And the query is close to 255 fields - the max # of fields Access lets me use.
My original field names are small, ie, GPcnt, RPcnt, SBud, FBud........ I use IIF so that the fields will be null if a certain value is 0. Then, if the whole line is Null, it saves space. I have Can Grow and Can Shrink both set to yes.
Any ideas as to why this is happening and how to fix it would be appreciated.
I've been able to fix some of the problems by creating a new field (with a new name) in the query which is the same as the original field (that gives me an error on the report). That was okay for a couple fields (though I have no idea what the problem is and why that would fix it), but it looks like I'll need to do this for more fields. And the query is close to 255 fields - the max # of fields Access lets me use.
My original field names are small, ie, GPcnt, RPcnt, SBud, FBud........ I use IIF so that the fields will be null if a certain value is 0. Then, if the whole line is Null, it saves space. I have Can Grow and Can Shrink both set to yes.
Any ideas as to why this is happening and how to fix it would be appreciated.
