Solved

Data question

Posted on 2011-09-28
17
245 Views
Last Modified: 2013-11-05
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
0
Comment
Question by:chestera
  • 8
  • 6
  • 2
  • +1
17 Comments
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 334 total points
ID: 36812836
Possibly a negative amount ?

mx
0
 
LVL 8

Expert Comment

by:PeteEngineer
ID: 36812858
0
 
LVL 8

Expert Comment

by:PeteEngineer
ID: 36812866
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:chestera
ID: 36812924
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
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 166 total points
ID: 36814250
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
 

Author Comment

by:chestera
ID: 36818615
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
 

Author Comment

by:chestera
ID: 36860738
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
 
LVL 75
ID: 36861752
The s/b Currency if they really are currency.  Also, can you post a screen shot of this?

mx
0
 

Author Comment

by:chestera
ID: 36890063
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
 
LVL 75
ID: 36890101
Oh ... where you see the values like ($25.00)

Have we concluded these are negative numbers ?

mx
0
 

Author Comment

by:chestera
ID: 36890138
DatabaseMX

I did some research and ( ) represent  -value

Screen shot coming up

Alan
0
 
LVL 75
ID: 36890149
ah right ... minus value ... meaning Negative ....
0
 

Author Comment

by:chestera
ID: 36890178
DatabaseMX

sending screen shot

Alan
Problem-is-the-Interest-Earned-C.doc
0
 
LVL 75
ID: 36890186
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
 

Author Comment

by:chestera
ID: 36898075
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
 

Author Comment

by:chestera
ID: 36898078
fyed

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

Alan
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 334 total points
ID: 36898414
cool.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Question about Relationship and Userform in Access Database 17 54
Modal form 11 30
User Level Security 6 38
Dlookup MSACCESS 5 25
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question