union query

[Guest]

when i run a union querry acces is changeing the field format from a number
to text. I use the output of this querry to make a chart in excell. before i
would have months 1-12 now 1,10,11,12,2....

 

[MGFoster]

when i run a union querry acces is changeing the field format from a number
to text. I use the output of this querry to make a chart in excell. before i
would have months 1-12 now 1,10,11,12,2....

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Put a conversion function around the column w/ the month:

SELECT CByte(Month(sales_date)) As SalesMonth, .....

CByte() converts to a byte (0-255).
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRU/1bYechKqOuFEgEQJqWgCeMZ1nYIj6IKn3l9QAVNtPbayT+JYAoNb0
kbsqKOvrd/lRAQBFlAbBqGGl
=Wzhl
-----END PGP SIGNATURE-----

 

[Guest]

THANKS...
That gave me a work around, still don't know why is change after running for
years