Yes/No Format

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

Guest

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
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top