chestera
asked on
Data question
Hi EE
I have a table with about 4000 records one column is currency I have noticed about 30 records in that column are bracketed ie ($25.00) what's the significant of this
chestera
I have a table with about 4000 records one column is currency I have noticed about 30 records in that column are bracketed ie ($25.00) what's the significant of this
chestera
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
DatabaseMx
Thought so. I have the usual one to many tbl1 and tbl2 tbl one will have a value say $25.00 after an event that figure is appended to tbl2 and appears as ($25.00) there is no calculation involved
Alan
Thought so. I have the usual one to many tbl1 and tbl2 tbl one will have a value say $25.00 after an event that figure is appended to tbl2 and appears as ($25.00) there is no calculation involved
Alan
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
fyed
Thank you for that. What I can't understand is at the moment I have approx 4,000 records and it's only happened to about 10 fields. I would have thought if formatting problems all would have a problem. Fields are set as currency.
Alan
Thank you for that. What I can't understand is at the moment I have approx 4,000 records and it's only happened to about 10 fields. I would have thought if formatting problems all would have a problem. Fields are set as currency.
Alan
ASKER
fyed
property of a all fields concerned are Currency and decimal places are 2 and input mask is blank. I noticed that the varibles are down as Double should they be Currency.
Alan
property of a all fields concerned are Currency and decimal places are 2 and input mask is blank. I noticed that the varibles are down as Double should they be Currency.
Alan
The s/b Currency if they really are currency. Also, can you post a screen shot of this?
mx
mx
ASKER
DatabaseMX
It's a small loans dB with the fields I am talking about are Currency. Typical fields Loan amount, Balance and interest accrued. What would you like a screen shot of
Alan
It's a small loans dB with the fields I am talking about are Currency. Typical fields Loan amount, Balance and interest accrued. What would you like a screen shot of
Alan
Oh ... where you see the values like ($25.00)
Have we concluded these are negative numbers ?
mx
Have we concluded these are negative numbers ?
mx
ASKER
DatabaseMX
I did some research and ( ) represent -value
Screen shot coming up
Alan
I did some research and ( ) represent -value
Screen shot coming up
Alan
ah right ... minus value ... meaning Negative ....
ASKER
Pretty sure that means a Negative amount. Of course the question is ... Interest would not be negative. So, there must be a calculation error somewhere. But nonetheless ... the parens indicate a Negative value.
Time to hit the sack here ...
mx
Time to hit the sack here ...
mx
ASKER
DabaseMX
Thank you for your support. Iwill close this question. I will take fyed advice and check my formating. I will also split the points with you and fyed.
Alan
Thank you for your support. Iwill close this question. I will take fyed advice and check my formating. I will also split the points with you and fyed.
Alan
ASKER
fyed
Thank you for yor advice. I will split the points with you and DatabaseMX
Alan
Thank you for yor advice. I will split the points with you and DatabaseMX
Alan
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://stackoverflow.com/questions/3932734/how-to-place-negative-value-into-brackets