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
chesteraAsked:
Who is Participating?
 
Dale FyeConnect With a Mentor Commented:
Take a look at the formatting of the field, in the table definition or in the query you are using to present the data.  Might also need to check the formatting of the control that is displaying the data.

Lastly, I'd check the routine that "appends" the data to tbl2 and make sure it is not using a negative or subtracting this value from another field, which might be zero.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Possibly a negative amount ?

mx
0
 
PeteEngineerCommented:
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
chesteraAuthor Commented:
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
0
 
chesteraAuthor Commented:
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
0
 
chesteraAuthor Commented:
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
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
The s/b Currency if they really are currency.  Also, can you post a screen shot of this?

mx
0
 
chesteraAuthor Commented:
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
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Oh ... where you see the values like ($25.00)

Have we concluded these are negative numbers ?

mx
0
 
chesteraAuthor Commented:
DatabaseMX

I did some research and ( ) represent  -value

Screen shot coming up

Alan
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
ah right ... minus value ... meaning Negative ....
0
 
chesteraAuthor Commented:
DatabaseMX

sending screen shot

Alan
Problem-is-the-Interest-Earned-C.doc
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
0
 
chesteraAuthor Commented:
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
0
 
chesteraAuthor Commented:
fyed

Thank you for yor advice. I will split the points with you and DatabaseMX

Alan
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
cool.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.