Can I give a defined field length to a Expression defined field i.

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

Guest

Can I define a field length for a expression field in a Query? I need the
ODBC driver to recognize a field length in a calculated field (I.E. - exp1:
[field1] + [field2])
 
Bob said:
Can I define a field length for a expression field in a Query? I need the
ODBC driver to recognize a field length in a calculated field (I.E. - exp1:
[field1] + [field2])
Click to expand...

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

If it is a numeric data type you can use a conversion function on it.

CInt(col1 + col2)

You have to know the data type equivalences between Access & the other
DB. IOW, An Integer in Access/JET is 2 bytes; in SQL Server it is 4
bytes; etc.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBQij29IechKqOuFEgEQJA/gCfSGgnPCxWlqIqdYMxNozeQiPj6PEAn1XL
KAErnjSle2Apltp5YNqk7NUz
=G14m
-----END PGP SIGNATURE-----
 
Back
Top