Results 1 to 4 of 4
  1. #1
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568

    Convert Bytes to Gigabytes

    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

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,129
    Divide by 1024 three times to get kilobytes, megabytes and gigabytes in turn
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  3. #3
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    You mean 1649267441664/(1024 * 1024 * 1024)?

    Thank you ridders52!

    Best,
    Jacek

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,129
    Yes i did mean that
    EDIT - With that size perhaps divide by 1024 again to get terabytes?
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. to convert SQL to VBA!!!!!!!!!!!
    By mathhero in forum Access
    Replies: 1
    Last Post: 10-30-2015, 07:34 AM
  2. convert to mde
    By linoreale in forum Access
    Replies: 5
    Last Post: 05-14-2015, 09:09 AM
  3. How to Export Access memo field 87,000 bytes
    By JosmithTwo in forum Import/Export Data
    Replies: 3
    Last Post: 08-10-2012, 02:16 PM
  4. How to convert a db to txt
    By Joliet_Jake in forum Import/Export Data
    Replies: 5
    Last Post: 11-01-2010, 12:07 AM
  5. Show array of bytes as picture in form
    By HZwaan in forum Forms
    Replies: 0
    Last Post: 06-17-2010, 04:07 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums