Recent content by frankb

Sorry, my explanation stunk... The place my formula is breaking is when I've got a date that falls into a partial week at the start of a month. 02/02/2006 should return "5" for the 5th week of January. I guess that what I need is a way to determine if a date falls into a partial week at the...

I need a formula that will return the nth full week of the month that specified date falls in. Example: 03/31/2006 would be "5" - the fifth full week of March 20/13/2006 would be "2 - the second full week of February I've tried using a formula that subtracts the week number for the 1st of...

I've gotten a request from a user to change the order that a report groups by depending on a part#. If the Part# field is <80000, then they want it to be grouped by Specie then Detail#, if it's >= 80000, they want to group by Detail# and then Specie. I was going to try using two sub-reports...

It needs to be more dynamic and require far less user input than this. I'm working with our church secretary and this needs to be user friendly for a couple of users who are not very PC literate. The example I gave gives the impression that I would only have 2 records per page, but the reality...

The mulit-column aspect is a piece of cake, as is the double-sided printing. The problem is getting the right records to print in the right location on the report. I can manually force the print job to happen correctly, but I need to have this automated as records are added and removed. I...

Any ideas??

I'm trying to print an address book that will consist of landscape pages folded in half. How do I get the addresses to print in the correct order to flow from page to page? I'm not sure if I'm making myself clear, so I'll try to add more detail. If I have an address book that has 10...

thx, too easy.

I've got a similar problem, only I'm getting the To and From dates from a form. What's kicking my butt is the fact that my query is not returning the To dates. In other words, it's querying the From date inclusively and the To date exclusively so my query never returns any data for the To...