ambiguous name. in query expression

[יריב החביב]

hello,

i wrote expression in query and i work fine.

when i import this query to another (but the same) application

it gives me the error statment above.

what can be the reason ?

 

[יריב החביב]

thank you !

yes,

but it work in other (the same ) application.

if i try to change the name (one of them)

the query (based on mudole function) doesnt work.

thanks

 

[Sheila D]

are u using the same field name twice in your query?

 

[John W. Vinson]

hello,

i wrote expression in query and i work fine.

when i import this query to another (but the same) application

it gives me the error statment above.

what can be the reason ?

If you use the same fieldname twice, you MUST explicitly name the table: put
[tablename].[fieldname] wherever you refer to the field, so Access can tell
which table's field you mean.

It's also a good idea to define an Alias name: in the query grid put

NewName: [tablename].[fieldname]

where NewName is some name not used elsewhere in the query.

John W. Vinson [MVP]

 

[יריב החביב]

thank you john !!!
--
תודה רבה

hello,

i wrote expression in query and i work fine.

when i import this query to another (but the same) application

it gives me the error statment above.

what can be the reason ?

If you use the same fieldname twice, you MUST explicitly name the table: put
[tablename].[fieldname] wherever you refer to the field, so Access can tell
which table's field you mean.

It's also a good idea to define an Alias name: in the query grid put

NewName: [tablename].[fieldname]

where NewName is some name not used elsewhere in the query.

John W. Vinson [MVP]