Convert Binary to Number

[dastr]

hallo all,

I have a column (in a table) populated by binary values and I would like to have this converted to NUMBER. Is that possible by an Update Query?

My table is called INDEX;
the column is called SIZE

Kinldy share with me yr thoughts on this.
Thx

 

[Trevor G]

Have you looked at the Field properties what do you want to adjust it to?

 

[spikepl]

You may want to check this list of reserved words: http://allenbrowne.com/AppIssueBadWord.html

 

[MStef]

Look at "DemoBinaryA2003.mdb" (attachment, zip).
Look at Table, Forms (VBA), Queries, Module1.
Open MainForm and try.
I think it is what you want, adapt it in your mdb.
As SPIKEPL said, INDEX and SIZE are reserved words in Access.