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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dynamic table creation problem

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Joined
Jan 1, 1970
Messages
0
Hello,

I'm have table that gets created by a makeTable query, after it's not needed it get deleted.

The table get created with two columns, the second one holds a number. Is there a way of getting the second column to format to 5 decimal places, instead of auto, everytime the table is created?

Thanks for the help in advance

Kris
 
Sort by date Sort by votes
You can force the make table query to display the number using the format function:

Column2: Format([MyField],"0.00000")

HTH Joe Miller
joe.miller@flotech.net
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

raywood1
  • Locked
  • Question Question
Reducing a Massive Linked Table
Replies
4
Views
1K
dhookom
dhookom
JayRo71
  • Locked
  • Question Question
Saved Imoorts problem with file name
Replies
10
Views
1K
Andrzejek
Andrzejek
03Explorer
  • Locked
  • Question Question
Refreshing a linked table (housed on MS SQL Server) now breaks
Replies
3
Views
848
dhookom
dhookom
JayRo71
  • Locked
  • Question Question
Importing only unique records from excel tables
Replies
10
Views
1K
SkipVought
S
MrStohler
  • Locked
  • Question Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship?
Replies
5
Views
1K
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top