Which field to use

Hi,
I need to store the web visitor's IP in a field. I thought of creating a
numeric field but I've been told that because the IP has numbers and dots
should be stored as text. However, if I choose text I cannot group by it.
What's your opinion?
Of course...newbie here.
TIA
Ana


.

Relevant Pages

  • Re: creating table with datatype smalltime
    ... You can't store this datatype directly into a table. ... and I would do this in a numeric field that has a Single field ... display the the data from seconds into your desired format. ... <MS ACCESS MVP> ...
    (microsoft.public.access.tablesdbdesign)
  • Re: The quibble over nibbles (was Re: MVS Packed Decimal with no sign nibble?)
    ... numeric field is implicitly positive if used in math? ... only IBM engineers seem to be so impaired. ... You would not use a numeric field to store those, ... Sun Valley Systems ...
    (comp.lang.cobol)
  • Re: Data type and relationships
    ... store now? ... Is there a reason you can't just add a new field to hold the new text value? ... Will adding a new text value result in redundant data being stored? ... I'm trying to enter text into a numeric field. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: numeric fields
    ... Select the numeric field. ... The integer types can only store whole numbers. ... The format and number of decimal places only affects how the number is ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Help Using DlookUp on a Form
    ... > I have a table called tblStoreOrders with a key field name (a ... > My form name is frmStoreOrders with a combo box call "Store" (This has ...
    (microsoft.public.access.forms)
Loading