Search results for query: *

The situation is extrememly odd. If I change the 10/3/00 date for Patrick Brown to 8/25. The records will group correctly and place his two records with the 8/35 date. If I leave it as 10/3 the records group (only his) by the 10/3 date instead of the 9/6/00 date like it should. Why would one...

I tinkered with the code a little and everything is now working except for the first set of records it finds. (In the first query I had to use a combination of first and last to make Access behave.) The first group it finds puts the listing with the second date. See how it throws Patrick...

swilliams gave me great help on my problem but I have one little tweak that needs attention. Swilliams are you out there? IE: Thread 222-45160 Report Problem The code works great but the groupings come out in reverse order. IE: Jim Smith 8/12/00 Mike Will 9/10/00 Jenny King 11/25/00...

I have: If Page = Pages Then subtot.Visible=False Else subtot.Visible=True EndIf End Sub

This works to move the pagefooter where I want it but it still prints the footer at the bottom of the last page. The field is a calculated field, would that make a difference.

swilliams gave me great help on my problem but I have one little tweak that needs attention. Swilliams are you out there? The code works great but the groupings come out in reverse order. IE: Jim Smith 8/12/00 Mike Will 9/10/00 Jenny King 11/25/00 Jenny King 10/25/00 Jenny King...

I put the following code in my report to subtotal each page. Dim x As Double PageFooter Print pagesum = runsum - x x = runsum ReportHeader Print x = 0 The subtotals are printed at the bottom of each page which is great but on the last...

You may find help in article Q132017 in the MS knowledgebase. I just used this to add subtotals on each page and then a grand total at the end. You may be able to modify this to help.

Thank you so much. I hope I can return the favor someday.

This looks like it will help but I'm running into a problem that possibly you could help me with. This is the code I type in SELECT [90 days].Name, first([90 days].[Payment Due]) as [payment due] FROM [90 days]; The table it is pulling from has the following columns: Acct No, Payment Due...

I am hoping this problem can be solved by someone with a good VB background because I can't do it with the tools in Access. I have a report that must be sorted on the column called Payment Due. This works fine except that if a person appears twice in the report they need to be listed...

If I add a group section through Sorting and Grouping it requires a sort. Any other ideas?

I have a report that I am having difficulty getting to sort the way it is needed. I am suspicious that I need some VB help. I have a report that I need sorted by the column Payment Due except in the case that a person is listed in the report twice. If the person is listed twice, the names...