Recent content by jrmondonedo

Hi! I created a report that would generate, among others, a listbox on monthly payments. How do I make it spill-over to the next page when its contents have already exceeded that of a single paper? Please help! Thanks.

(SOLVED) Help on Report After a lot of experimenting, I'm back at last! By using left join on the relationship, the report is now showing records with null values on the ORNumber column :D This is the code I used: SELECT tmp.PaymentDate, tmp.MemberID, tmp.ORNumber, tmp.Description...

I think I almost nailed it by using the sql whatchamacallit code below :) SELECT tmp.PaymentDate, tmp.MemberID, tmp.ORNumber, tmp.Description, Count(tmp.MemberID) AS NoOfPayees, Sum(Payments.Amount) AS TotalOfAmount FROM (SELECT PaymentDate, MemberID, ORNumber, Description, Amount FROM Payments...

Hi! I hope someone can help me out on a question... I have a report composed of a number of expandable list boxes. The problem is that these list boxes tend to overlap with the succeeding list box when they expand to show its contents. Is there a way to set the position of each list box to...

Theoretically, you're correct and I see what you're trying to drive at :) Thanks for pointing it out. What I wish to show on the report are the following: 1. Total payments received for the period specified by a user; 2. Total number of members who paid for the same period; and, 3. Rate...

That's right; ideally, the report will be used to capture total cash payments received every single month or a specific period specified by the user. However, the report details also show a breakdown of different months covered for lump sum payments or current payments intended to cover...

(SOLVED) Help on Report Again, I'm stumped and was left with twiddling my thumb because of the report I want to create :banghead: The report is based on two related tables: (1) Members (Primary Key: Member ID); and, (2) Payments (Foreign Key: Member ID). The contents of the report are...

Hey again :) Got it this time. Just made some adjustments on the report and everything displayed as I would want it to. Yout assistance is much appreciated.

That's what I did right after posting my response and it's running as expected: income before expense. I think I might be doing sumthing wrong with the report... Any advise on how I'm supposed to proceed?

HI! Appreciate the prompt advise. I created a new query using the sql construction you provided but after creating the report using the new query it's still displaying expense before income. Apologies but I'm totally green when it comes to these things.

I created an Income/Expense Report from two separate queries so I made a Union Query with the following SQL construction: SELECT [Transactions Extended].* FROM [Transactions Extended] WHERE ((([Transactions Extended].[Income/Expense])="Income")); UNION ALL SELECT [Transactions Extended].* FROM...

Hi David :) I wasn't kidding when I mentioned in my intro that we're still using record keeping methods from Jurassic Era :o Your good luck worked wonders because just this afternoon during an impromptu meeting, the chaps from my organization asked to see how I'm going with my modernization...

Yes, I did.

Thanks much for your prompt reply and willingness to help. The size of my file exceeded the cap imposed by the site - it has already reached 4.1 mb :mad: Would there be a workaround, perhaps, so you'll be able to see the file?

I'm really stumped :banghead: on my lame attempt to create a database for our organization, a homeowners association, because of an error message I'm getting by merely clicking on a subform; the error message says: "The changes you requested to the table were not successful because they would...