Viewing Binary Fields

[TomG]

I have imported in MS Access 2003 a SQL Server table that has binary id
columns. When I look at the design view for the table, the column type is
binary -- which is strange since I thought binary was not a valid column
type. The column contains the binary represntation of a numeric sequential
id.

I want to see the number on a query or report. I have searched for a
fucntion that will convert the binary column to a visisble number -- without
success? Does anyone know of a function that will work? If not, does anyone
have any ideas on how you would write the vba code to perform the conversion?


Any help would be appreciated.

 

[JamesDeckert]

in a query try clng([field]) to convert to a long.

to convert -
In the design view of the table, change the definition to what you want it
to be and Access will do the conversion for you. If it can't it'll tell you.

James