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

Adding fields

Status
Not open for further replies.
istone

istone

IS-IT--Management
Jan 24, 2007
139
US
Hi,
i am trying to add two fields but the result is weird

[Disbursements]+[Total Amount]

i get

16$1,104.87

it should 16 + $1,104.87 = 1,120.87

Thanks in advance
 
Sort by date Sort by votes
Problem solved. the field was a test not a number.
thanks
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

atadbitslow
  • Locked
  • Question
comparing fields, one populated with data and one blank 2
Replies
8
Views
466
atadbitslow
atadbitslow
BallunarCrew
  • Locked
  • Question
Can I map fields when connecting to SQL Server thru ODBC? 1
Replies
1
Views
126
dhookom
dhookom
kentover
  • Locked
  • Question
MS Access Linked to SQL Server Numeric Fields Lose Precision and Scale 1
Replies
7
Views
290
kentover
kentover
Paul_W
  • Locked
  • Question
Access query calculated fields not exporting to excel 1
Replies
8
Views
213
Paul_W
Paul_W
weightinwildcat
  • Locked
  • Question
Count of columns/fields in a query or table.
Replies
1
Views
100
MajP
MajP

Part and Inventory Search

Sponsor

Back
Top