Since it is numeric sorting it will put it order like this: 1, 10,11,12.....
When I leave it as it was entered in the form it is in order as it should be.
Adding Group 1 is what is creating the disorder. Can't find away around it, so far.
Since it is numeric sorting it will put it order like this: 1, 10,11,12.....
When I leave it as it was entered in the form it is in order as it should be.
Adding Group 1 is what is creating the disorder. Can't find away around it, so far.
I didn't add any grouping to your report. I just change those two properties of the Footer.
Removing the group =1 doesn't give me what I need for the total and signature. Everything works great except the Ref# order.
I tried removing the new group and checked the report footer and they were both set on none.
Does this one work the way you want?
How about this one?
I was able to get that but I have to have the signatures and total to follow the information as I have in the new DB. Here is the latest one.
In order to know what I am talking about youmust look at it in print preview.
Here it is back with the group removed.
OK. I see what you are talking about now.
MVP Duane Hookom gave me the answer. Open the Report property sheet and go to the Format tab. Page Header needs to be set to "All Pages". The footer then starts printing right after the Detail section.
That worked perfectly. Thanks!!!!!
Go ahead and follow the link in my sig and mark this thread as Solved.