Solved

Data question

Posted on 2011-09-28
17
226 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
 

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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Suggested Solutions

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server views 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 Access…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

708 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now