I have devised a report which gives the following type of information for a single month:
ACCOUNTS OPENED
John Smith
Richard Jones
ACCOUNTS CLOSED
Jim Arnold
TOTAL OPEN AT END OF MONTH: 37
The data all comes from a single table and is presented using 3 sub reports, each fed with a suitable...
Access is giving me strange results for perfectly straightforward calculations. For example, try the following in the Immediate window of VBA:
1108.91 - 306.38 - 802.53
The answer should be 0 (or 0.00) but is actually 1.13686837721616E-13 (which in non-scientific display is 0.000000000000114...
I have a large Access system (Office 2003, Windows XP Pro) which comprises the main program file with all forms, queries, reports and VBA and then 4 data files which share the 50+ tables feeding the system each table being linked into the prog file. I experience unpredicatble problems when doing...
I have a number of Excel files which are populated by data exported from Access. One of the files is behaving most oddly! It's charts have data tables on them and the data tables show different figures from the source data. Opening the file for the first time this month, I see that the data...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.