I know it's possible, just don't know how to do it. I have a
spreadsheet that I imported into access. Two of the columns in the
table have Hard Drive space values listed for example 2.45 GB and 453
MB, you get the picture. Both the GB and MB assorted values exist in
both columns.
Is there anyway to convert the GB or MB to 0's, or even better yet
decimal places so I can look for values < or > to 6gb. I already tried
a query, but it seems that in it's current format, access can't
properly run the query, because it's only looking at the numeric value
and not the gb or mb attached to it.
Or is it simpler to do in Excel?
TIA,
Brian