Query Imposing Field Name

[LoopyNZ]

Hi,

(Access 97)

I'm creating a query (QRY_SUMMARY) to join a query (QRY) to itself
(QRY_1). I'm returning QRY.* and selected fields from QRY_1. With each
field (field_name) I return from QRY_1 I'm appending "_1" to to the end
to avoid name conflicts with the fields from QRY, i.e. "field_name"
becomes "field_name_1".

It's all working fine, with one exception. ONE field from QRY is coming
through with the name "QRY.field_name" instead of just "field_name".
This is in spite of the fact that there IS no name conflict - the same
field from QRY_1 has been aliased as "field_name_1". (I have about 10
other fields, and they work with no problem.)

So far I've done the following (to no avail):
- recreated QRY_SUMMARY by cutting and pasting the SQL;
- compacted and repaired the database;
- checked that the original query has no naming conflicts;
- checked that there is no caption set on the source field.

(Additionally, I'm having trouble referring to the field
"QRY.field_name" in a subsequent formula in a report: it doesn't
understand "[QRY].[field_name]", "[QRY.field_name]" or
"[QRY_field_name]".)

Any ideas?

------------
LoopyNZ
------------

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Allen Browne]

Is there anything in the Caption property of the problem field in the table?

That can cause Access to display the Caption name instead of the actual
field name or alias from the query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"LoopyNZ" <Lo*****@NOguruSPPAM.net.nz> wrote in message
news:41**********************@news.newsgroups.ws.. .

(Access 97)

I'm creating a query (QRY_SUMMARY) to join a query (QRY) to itself
(QRY_1). I'm returning QRY.* and selected fields from QRY_1. With each
field (field_name) I return from QRY_1 I'm appending "_1" to to the end
to avoid name conflicts with the fields from QRY, i.e. "field_name"
becomes "field_name_1".

It's all working fine, with one exception. ONE field from QRY is coming
through with the name "QRY.field_name" instead of just "field_name".
This is in spite of the fact that there IS no name conflict - the same
field from QRY_1 has been aliased as "field_name_1". (I have about 10
other fields, and they work with no problem.)

So far I've done the following (to no avail):
- recreated QRY_SUMMARY by cutting and pasting the SQL;
- compacted and repaired the database;
- checked that the original query has no naming conflicts;
- checked that there is no caption set on the source field.

(Additionally, I'm having trouble referring to the field
"QRY.field_name" in a subsequent formula in a report: it doesn't
understand "[QRY].[field_name]", "[QRY.field_name]" or
"[QRY_field_name]".)

Any ideas?

------------
LoopyNZ
------------

[LoopyNZ]

Thanks Allen, but I've been tripped up by that before, so I'd already
checked that and there aren't any captions set in the source table or
the source queries.

I think I'm going to have to do an ugly workaround in my report, i.e.
use a DLookup to retrieve the field, since I can't manage to refence it
properly.

------------
LoopyNZ
------------

--- QUOTED MESSAGE ---

Query Imposing Field Name
From: LoopyNZ
Date Posted: 11/4/2004 4:33:00 AM

Hi,

(Access 97)

I'm creating a query (QRY_SUMMARY) to join a query (QRY) to itself
(QRY_1). I'm returning QRY.* and selected fields from QRY_1. With each
field (field_name) I return from QRY_1 I'm appending "_1" to to the end
to avoid name conflicts with the fields from QRY, i.e. "field_name"
becomes "field_name_1".

It's all working fine, with one exception. ONE field from QRY is coming
through with the name "QRY.field_name" instead of just "field_name".
This is in spite of the fact that there IS no name conflict - the same
field from QRY_1 has been aliased as "field_name_1". (I have about 10
other fields, and they work with no problem.)

So far I've done the following (to no avail):
- recreated QRY_SUMMARY by cutting and pasting the SQL;
- compacted and repaired the database;
- checked that the original query has no naming conflicts;
- checked that there is no caption set on the source field.

(Additionally, I'm having trouble referring to the field
"QRY.field_name" in a subsequent formula in a report: it doesn't
understand "[QRY].[field_name]", "[QRY.field_name]" or
"[QRY_field_name]".)

Any ideas?

------------
LoopyNZ
------------
Re: Query Imposing Field Name
From: Allen Browne
Date Posted: 11/4/2004 4:53:00 AM

Is there anything in the Caption property of the problem field in the
table?

That can cause Access to display the Caption name instead of the actual
field name or alias from the query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!