I have set up a union query that displays a yes/no field. On the original
table the results show as a yes or a no, but in the query they show as a -1
or a 0. The best i have come up with is:

& Format ([UnitPass - Yes/No?],("Yes/No"))

but this shows as -1Yes and 0No.

In the same query there is a field that in the original table has a format
of "CD23-"# so CD23 goes infront of the number. This also messes up when
displayed in the query and just shows the number. I have tried:

& Format ([CD23TestNo],("&CD23-&"))

but this does the same: 1CD23-1, 2CD23-2 and so on.

Any help much appreciated.

Thanks

hey
Question for you it seems like we are working on the same thing.

Can you update a Union query? so say in your query change a Yes to a no?
Thanks

"enrico1982" wrote:

> I have set up a union query that displays a yes/no field. On the original
> table the results show as a yes or a no, but in the query they show as a -1
> or a 0. The best i have come up with is:
>
> & Format ([UnitPass - Yes/No?],("Yes/No"))
>
> but this shows as -1Yes and 0No.
>
> In the same query there is a field that in the original table has a format
> of "CD23-"# so CD23 goes infront of the number. This also messes up when
> displayed in the query and just shows the number. I have tried:
>
> & Format ([CD23TestNo],("&CD23-&"))
>
> but this does the same: 1CD23-1, 2CD23-2 and so on.
>
> Any help much appreciated.
>
> Thanks

Sorry as far as i know, no. You can in a normal query but not in a union. I
have looked at the two in sql and there arn't any extra bits of code that
might set it.


"Matt_Fairfield" wrote:

> hey
> Question for you it seems like we are working on the same thing.
>
> Can you update a Union query? so say in your query change a Yes to a no?
> Thanks
>
> "enrico1982" wrote:
>
> > I have set up a union query that displays a yes/no field. On the original
> > table the results show as a yes or a no, but in the query they show as a -1
> > or a 0. The best i have come up with is:
> >
> > & Format ([UnitPass - Yes/No?],("Yes/No"))
> >
> > but this shows as -1Yes and 0No.
> >
> > In the same query there is a field that in the original table has a format
> > of "CD23-"# so CD23 goes infront of the number. This also messes up when
> > displayed in the query and just shows the number. I have tried:
> >
> > & Format ([CD23TestNo],("&CD23-&"))
> >
> > but this does the same: 1CD23-1, 2CD23-2 and so on.
> >
> > Any help much appreciated.
> >
> > Thanks

Damn ok i was hopeing to just change some stuff in the Query so i wrote back
to there respective tables.
Hmm seems like i am going to have to find a different way!
Thanks

"enrico1982" wrote:

> Sorry as far as i know, no. You can in a normal query but not in a union. I
> have looked at the two in sql and there arn't any extra bits of code that
> might set it.
>
>
> "Matt_Fairfield" wrote:
>
> > hey
> > Question for you it seems like we are working on the same thing.
> >
> > Can you update a Union query? so say in your query change a Yes to a no?
> > Thanks
> >
> > "enrico1982" wrote:
> >
> > > I have set up a union query that displays a yes/no field. On the original
> > > table the results show as a yes or a no, but in the query they show as a -1
> > > or a 0. The best i have come up with is:
> > >
> > > & Format ([UnitPass - Yes/No?],("Yes/No"))
> > >
> > > but this shows as -1Yes and 0No.
> > >
> > > In the same query there is a field that in the original table has a format
> > > of "CD23-"# so CD23 goes infront of the number. This also messes up when
> > > displayed in the query and just shows the number. I have tried:
> > >
> > > & Format ([CD23TestNo],("&CD23-&"))
> > >
> > > but this does the same: 1CD23-1, 2CD23-2 and so on.
> > >
> > > Any help much appreciated.
> > >
> > > Thanks