Thanks, I ended up dusting of my rusty MS Access code skills and wrote"on print" code that stored the value of the previous lease vacation date and calculated this with the current lease start date an passed the result into a custom field value in the report.
I have a report that groups a property with any leases it has had during a given period. How can I calculate the days the property was vacant based on a field in the previous record's lease vacating date and the next lease start date, i.e.:
Property
Lease 1 Start Date / End Date /...
To anyone else that has this problem, Microsoft came back with the following:
http://support.microsoft.com/kb/2567053
It didn't work the first time so the uninstalled and reinstalled following the article below
http://support.microsoft.com/kb/897225
I have a Windows Server 2003 (SP2) that is experiencing 0x0000008e crashes when a user logs off and their session closes. Not all users are casuing this error and it is occuring about twice a week. To date only Accountants who use software specific to their needs are causing these random...
Is it possible to return a true value when comparing stings that are only similar and not identical??
I have a list of current folder names and a list of desired folder names. I want to match a current folder name with a similar desired folder name i.e.
Jane, Smith and Jane Smith
ABC Family...
Thanks everyone for their suggestions - much appreciated. I have tried CMPs suggestion and have that working OK.
I have found that the Progress bar moves slowly and the screen isn't repainted or refreshed often enough to give a smooth effect.
When I have more time on the weekend I will try...
I have developed a database that often has to process and calculate many sales records at one time - up to 20,000. While this processing is under way there is sometimes a considerable pause or time when nothing appears to be happening from the user's point of view.
What is the best way to show...
Is it possible to have a main report print on Portrait and then have a sub report print on a new page but on landscape.
My research on this shows mostly that it cant be done and any other solutions I have tried so far do not seem to work.
The SQL code is as follows:
SELECT MYOB_Cards.Name, MYOB_Sales.InvoiceNumber, MYOB_Sales.TotalLines, Sum(MYOB_Sales.TotalLines) AS SumTot
FROM MYOB_Cards INNER JOIN MYOB_Sales ON MYOB_Cards.CardRecordID = MYOB_Sales.CardRecordID
GROUP BY MYOB_Cards.Name, MYOB_Sales.InvoiceNumber...
I have what should be a simple problem, however I can't work it out.
I have a report that is grouped by client and the details section lists all invoices purchased for that client. I have supressed the details section of the report as all I need to see is the sum of all the invoice totals for...
Hi
I have created a sub report that sits within the details section of the main report. I have also created a shared variable which passes the total from the sub report to a formula in the main report's group footer.
This works sucessfully until I supress the details section on the main...
Is it possible to display text typed into a text box on a form with stars (****) instead of the actual word entered and still have the actual word enterd accepted as the text box value?
Is it possible to read all fields from a table into an array or is there an alternative solution?
I have a report that is grouped on Photocopy Machine Model then grouped by Machine number and then grouped by technician.
The idea is to look at the machine's meter reading from each service call...
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.