Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Twinmammy

    losing decimal when loading to MS access

    Thanks all, its a reference number for some actions. I create reports out of access by popping data back into excel in a different formay (I receive many files monthly that need to be collated into a database and then reported) But in excell its ordering the actions in the pivot tables like...
  2. Twinmammy

    losing decimal when loading to MS access

    Thanks Cindyk, I have it set to Double but I'm still having issues! It now seems to be where I have two decimals like 10.2.1. Can this be done as a number or would it have to be text?
  3. Twinmammy

    losing decimal when loading to MS access

    also, if I open the table in access and try to type 1.1 the .1 immediately dissappears!
  4. Twinmammy

    losing decimal when loading to MS access

    I'm trying to load some data to a table in access from excel. When I load it to an existing table (field settings are set at Decimal auto decimal places), I lose the decimal and the numbers after! any advice? Thanks

Part and Inventory Search

Back
Top