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

Datatype issue

Status
Not open for further replies.
mikeyb540

mikeyb540

Programmer
Jul 7, 2003
173
US
I am having trouble with a SQL Server 2000 datatype in MS-Access 2000.

In SQL server it is a Numeric (6, 4) or 0.0123 or formatted as 1.23%

MS-Access link object to table the datatype becomes Currency so my value becomes $0.01 and I cant convert it to a percent.

Any ideas?

Please, help ! ! !
 
Status
Not open for further replies.

Similar threads

cortextual
  • Locked
  • Question
Referential integrity issue: no unique index found for the referenced field of the primary table
Replies
2
Views
679
MajP
MajP
rekrabnai
  • Locked
  • Question
Oracle 11g issue with VBA connection
Replies
3
Views
228
PHV
PHV
cicoa
  • Locked
  • Question
ACCESS 2007 Junction Table issue
Replies
3
Views
140
cicoa
cicoa
lmcc007
  • Locked
  • Question
Bookmark issue
Replies
11
Views
265
MajP
MajP
dpimental
  • Locked
  • Question
Oracle Linked Table Issue
Replies
1
Views
101
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top