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" wrote:

> are u using the same field name twice in your query?
>
> "יריב החביב" wrote:
>
> > 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 ?
> > --
> > תודה רבה

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

"יריב החביב" wrote:

> 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 ?
> --
> תודה רבה

On Tue, 27 Mar 2007 16:04:09 -0700, ???? ????? <(E-Mail Removed)>
wrote:

>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 !!!
--
תודה רבה


"John W. Vinson" wrote:

> On Tue, 27 Mar 2007 16:04:09 -0700, ???? ????? <(E-Mail Removed)>
> wrote:
>
> >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]
>