Re: Data type and relationships

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Ruth

I'm with Rick - why?

Can you give an example of what used to be stored, and what you want to
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?

A detailed description helps us offer detailed suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Ruth" <Ruth@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2010A349-0AAD-4F76-8B8B-705932E6837C@xxxxxxxxxxxxxxxx
First, I'm a beginner. Second I'm working with a database that has
already
been set up. However, I'm trying to enter text into a numeric field. How
can
I change this? I tried changing the data type, but it won't let me because
it's connected to several relationships.

Please Help.


.

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: 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)
  • Re: What type of Query and How
    ... If you already have a table with the "lookup" values, ... way to join the tables (by the code/account#), there's no reason you need to ... If you DO put redundant data in, what is your plan for ensuring ...
    (microsoft.public.access.queries)