Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Data question

Posted on 2011-09-28
17
Medium Priority
?
273 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 - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1336 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

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 49

Accepted Solution

by:
Dale Fye earned 664 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 - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 1336 total points
ID: 36898414
cool.
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

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

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

581 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