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!

Tables setup

Status
Not open for further replies.
bob1k

bob1k

Programmer
May 8, 2003
2
US
I need to have a field setup in a table, that is a number with 1 decimal place. When I put in a number it rounds the number and shows the decimal as 0(zero). What do I need to do to correct this problem?
 
Sort by date Sort by votes
What is the type for the field??? It must be single or double. By default Access assigns it long integer but integers do not store decimals....

****************************
Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III
MCSA, CNA, MCP, Network+, A+
w: robert.l.johnson.iii@citigroup.com
h: wildmage@tampabay.rr.com
 
Upvote 0 Downvote
I tryed that but then get "Too many fields defined" error when I try to save.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JayRo71
  • Locked
  • Question
Importing only unique records from excel tables 1
Replies
10
Views
543
SkipVought
S
MrStohler
  • Locked
  • Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship? 1
Replies
5
Views
387
SkipVought
S
puforee
  • Locked
  • Question
Best way to setup tables for multible related data sets
Replies
1
Views
312
dhookom
dhookom
Lidias13
  • Locked
  • Question
Odata contains fields from multiple tables in single table with different field names - for same
Replies
1
Views
323
dhookom
dhookom
oxicottin
  • Locked
  • Question
Creating tables and relationships for new database
Replies
2
Views
2K
MajP
MajP

Part and Inventory Search

Sponsor

Back
Top