Error when adding field

[jwrnana]

I am using the report "Aging Report for Accounts Receivable" that is based
on a query "Aging Report". This was one of the "Canned" reports with
access. I have added the field Account # to the query. When I preview
the query, it contains the correct information; however, when I go to the
report, of course, the field is missing. Therefore, I have added a field
using ab field function and using the control source from the query. When I
preview the report, I get the following: Enter Parameter Value

Receivables Aging Report Query
----
box to enter info ---
ok
cancel

Canceling takes me back to the design view; ok takes me to the report. The
heading is Account #, but the info listed beneath this is #Error. What am I
doing wrong? I have the Account # also in the customer info and also on the
invoice, but cannot seem to get it to print on this report.

Your assistance is greatly appreciated.

My email address has changed and I am not certain which one you are
receiving. The correct one is (e-mail address removed).

Joy Rose

 

[Evi]

if your field name really is 'Account#' rather than AccountNum then that
could be a problem. The # is used to denote a date in codes and functions.
Access can be a hypocrite about field names. It seems to accept them then
suddenly barfs up in a report or if you try to sort the field and gives you
no clue that its the name it doesn't like.

Evi