Microsoft Access Reports running afoul

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have MS Access which has been updated with MS Office SP3. (This SP updated
MS Office to make it show as Office XP when going for updates, although I
don't believe it really is XP.)
The database I'm managing has around 1100 records in the main table. This is
a Membership Database for a large Christian men's chorus. I need a report of
current members listed by their church for our current recruiting campaign.
The problem I am having is that I need information from two tables. Thus, I
have to create a query with the needed information, then I have to create a
report from that query.
The problem I'm dealing with has not come up in the past, but now it is
stopping me cold. When I opened last year's report I got the message, "The
specified field 'Member:LastName' could refer to more than one table listed
in the FROM clause in your SQL statement."
I have even created a completely new query, then created the report based
upon that new query, but when I try to view the data in Report View, I get
the same message and cannot access the information.
I am not a SQL programmer, so I do not know how to work around this problem.
Jack
 
LastName is a field in more than one table constituting the query; prefix
LastName with the desired table name like in [TableName]![LastName]
--
***************************
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?
 
That is precicely how it is prefixed. The field from one query shows
up as [Member]![LastName]. The field from the other query shows
up as[ContactMen]![LastName].

The problem may be that the "LastName" fields in both queries
actually come out of the "Member" table. Again, last year this
was working, but this year I am stopped cold each time I try to
open the Report.

Jack


S Panja said:
LastName is a field in more than one table constituting the query; prefix
LastName with the desired table name like in [TableName]![LastName]
--
***************************
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?


Jack M said:
I have MS Access which has been updated with MS Office SP3. (This SP updated
MS Office to make it show as Office XP when going for updates, although I
don't believe it really is XP.)
The database I'm managing has around 1100 records in the main table. This is
a Membership Database for a large Christian men's chorus. I need a report of
current members listed by their church for our current recruiting campaign.
The problem I am having is that I need information from two tables. Thus, I
have to create a query with the needed information, then I have to create a
report from that query.
The problem I'm dealing with has not come up in the past, but now it is
stopping me cold. When I opened last year's report I got the message, "The
specified field 'Member:LastName' could refer to more than one table listed
in the FROM clause in your SQL statement."
I have even created a completely new query, then created the report based
upon that new query, but when I try to view the data in Report View, I get
the same message and cannot access the information.
I am not a SQL programmer, so I do not know how to work around this problem.
Jack
Click to expand...
Click to expand...
 
Back
Top