I've got a strange problem with report of Access. Hope that some of you experienced this before & can help me out.
I've a table & make a select query to filter data. With that query I created a report (& here comes the problem !!!)
In my report, I need to make 2 levels of Group. Problem is when viewing the Sum of the 1st Group (i.e Sum(VND)), it's obviously wrong by missing a tiny amount (in attached image, it should be 27,207,103,000 i/o 27,207,102,720 as shown in MS Access report).
I tried using the Wizard report but it also show the same wrong figures !!!
Hope that some of you know the cause of this & help me. Thks.
My only thought is that these are calculated fields in the query? And, perhaps you are applying a format to the numbers. Then, when Access adds these numbers, it uses the original values--not the formatted/rounded numbers.
This can happen, from time to time. You have to be very careful when displaying and adding numbers.
My only thought is that these are calculated fields in the query? And, perhaps you are applying a format to the numbers. Then, when Access adds these numbers, it uses the original values--not the formatted/rounded numbers.
This can happen, from time to time. You have to be very careful when displaying and adding numbers.
Thanks twinnyfo.
In fact, these are numeric fields only. I just get back to the table & found out some records were not rounded numbers.
I think this is the cause of my problem & I need to re-check the whole table.
One more experience for myself, guy.
Thanks for your advice.
In my experience, Access reports are very reliable in grouping/summing functions, so when I see numbers that are off by just a smidge, I assume that there has to be something with the underlying values, rather than the report/function itself.
Yes, as your experience grows, you'll see things more clearly. you'll also find more complicated ways to be dumbfounded!
Hi all:
I've run into a problem that is confounding me. Hope you can help.
I have the following query (having removed alot of stuff for clarity:
SELECT tblComponent.TagNumber,...
Hi,
I have a report for which each record is a product.
I have the fields: ProductName and GroupCode
There may be several variants on each ProductName, BUT, with the same
group code
i.e.
Hi!
I have an Access 97 report based on tables linked to an SQL back end.
The report has 5 subreports in it (unfortunately unavoidable due to the
nature of the report) and performance is quite...
I'm new with VB 6 Data report.
I want to use it to create simple reports that can group by specified field.
Ex. Fields:
Doctor_Name
Address
Sched
Laboratory
Count(Laboratory) as LabCount
I have a report that is grouped by a field. I have looked for ways in which it would be possible to obtain an individual report for each group to export to PDF. Since if I have all groups in the...
Customer details are kept in the Customers_table with CompanyName as the
PK.
Tasks_table has TaskName, RatePerHour, and TaskCode (Two letter code
indexed no duplicates) as PK.
Jobs_table has...
Hi,
I wish to hide the group tree of the crystal report viewer programatically.
Intellisense denied any "DisplayGroupTree" property of the control!
A little googling yielded the fact that in VS...
I am producing a report in access. I have a field in a table that is a "Look-up Column". When I add the column to a report it prints out the line-item number vs. the text. For example if I have 3...
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...