Convert Bytes to Gigabytes

[jaryszek]

Hi Guys,

it is possible to convert Bytes to Gigabytes in Access Query?

Maybe function or only calculated field?

And how to do it?

In excel i have 1649267441664 and using function convert equals 1536.
In Access dividing this for 1024 is not working,


please help.

Thank you,
Best Wishes,

Jacek

[isladogs]

Divide by 1024 three times to get kilobytes, megabytes and gigabytes in turn

[jaryszek]

You mean 1649267441664/(1024 * 1024 * 1024)?

Thank you ridders52!

Best,
Jacek

[isladogs]

Yes i did mean that
EDIT - With that size perhaps divide by 1024 again to get terabytes?