G
Guest
Hey all
I'm using Count(*) in the Report Footer of one of my report to count each
record in the Details section. I'm having a error messages coming up
effectively saying "Database can't find the fields 'Bank' and 'Branch'
referred to in your expression - you may have misspelled the field name, or
the field may have been renamed or deleted".
I hit "OK" on both of these messages and then my report shows WITHOUT the
Bank and Branch controls. I get a perfect count - but without the information
in these fields (which makes it a little useless :-}).
The Report has a source query which is further filtered via a form dialog
box when the report is initiated. It also refers to the query (Lookup
expressions) to sort Bank and Branch alphabetically rather than referring to
ID number (that took me awhile to figure out!!)
Any ideas out there?
I'm using Count(*) in the Report Footer of one of my report to count each
record in the Details section. I'm having a error messages coming up
effectively saying "Database can't find the fields 'Bank' and 'Branch'
referred to in your expression - you may have misspelled the field name, or
the field may have been renamed or deleted".
I hit "OK" on both of these messages and then my report shows WITHOUT the
Bank and Branch controls. I get a perfect count - but without the information
in these fields (which makes it a little useless :-}).
The Report has a source query which is further filtered via a form dialog
box when the report is initiated. It also refers to the query (Lookup
expressions) to sort Bank and Branch alphabetically rather than referring to
ID number (that took me awhile to figure out!!)
Any ideas out there?