Replies

Brian, thanks for the info. I’ll be sure and check it out.

-Kelley

The controls are not overlapping. Even when I moved them away from each other, it still does not work.

I checked the top and height settings. Not sure what the height setting has to do with anything though, doesn’t that control the location of the control from the top of the section? The height of all the controls is 0.125. There are no other controls to the right of the address controls, as they are in the columnar format, one record displayed vertically, not the tabular going left to right. Since there are not any controls to the right, I’m not sure if I need to try the subreport feature. If I have time, I will try.

Thanks,

Kelley

Charlotte,

I tried that, and I’m still left with big gaping holes in the report. I’m very baffled by this. I would rather not post the entire database on here, is there any way that I can email you the database to look at individually? I’m hoping that I’m missing something really simple.

-Kelley

Don’t know that would work here because not all the same fields are blank. One one record, a person may only be missing a phone number, while on another record, that person may be missing an address. I don’t want to have separate queries looking for all the blanks on each field.

Mary,

Thanks for the comment. I have been recommending to my fellow employee NOT to use the graphic because many users will not want to use HTML as their default mail format. However, this persons insists on using the graphic. I appreciate your feedback.

-Kelley

This seemed to work! Thanks so much.

-Kelley

Geoff,

I appreciate the link to the article. I tried doing a search there before, but for some reason it didn’t find Julian. Must have been the way I was searching….

Will that solution really work in this case? The user said that the year number has been transposed in their system. (guess theirs is not really a tru Julian format?) When they see 10 for the year, it should really be 01. Is there a easy way to transpose numbers in Excel?

-Kelley

A user in a recent class proposed the following question to me. They have data that they are importing from another database system and it brings in the date in the following format, 10054, which she said is like a Julian format (which I’m not familiar with). 01 is the month. It’s just reversed when it’s brought in from their system. 054 is the 54th day of the year. So she said that 10 054 is really 2/23/01, the 54th day of the year.

Is there an easy way to convert that number into the correct date 2/23/01?

I know how to do Format Cells, but if you look at the way I explained the data, that will not work, especially when the year is reversed when the data is brought into Excel. If I click on that cell right now in the spreadsheet and try format dates, it thinks it’s July 11th, 1927 when it should be 2/23/01. I’ve attached the file to this posting.

Thanks so much for the help everyone. It worked! I even tried doing the AutoCorrect entry to make it easier and that worked too.

-Kelley

Charlotte,

Your suggestion about using the Abs(Sum[YesNoField])) to count the checkboxes worked, as long as I did that in the report footer. Is there any reason why this would not work if I tried to put it in the Page Footer? When I tried to enter it there, it only displayted #Error.

-Kelley

Yes, we did try using the Tools/Synchronize/Download Address book feature. The fact that it doesn’t even list an address book in the settings that’s throwing me off.