Search results

I have a report with lots of figures (in columns) and lots of spaces where the figure is presumably zero or null. How can I get the report to put a zero in all these blank spaces ?

Any chance of getting a copy of this could I could certainly make good use of it??

Abby, You can be as brusque as you like - it works great and your help is very much appreciated........Thanks, Glen

I have a Project tracking database in MS Access 97. I want to add a field to contain a "Baseline" date for the planned completion of the project. Once this date has been entered I want to lock it so it cannot be altered, although I still want it to be visible to all on the form. I thought it...

I have an Access report which formats the colour of the output based upon the results i.e. over 100% in Green, under 100% is in Red. I now want to e-mail this to other people and tried to export to Word to do this. Unfortunately whilst the layout remains in tact all the colours change back to...

I have given code for something similar under "E-Mail a single page from a multi-page report" dated Jan 10th. It will obviously need modifying but have a look as it should point you in the right direction.........Good luck

Hope this helps - a little while ago I had a similar problem where I had to hive off different sections of a report to different people. The code I used is below, which splits the report and outputs the seperate sections of the report into unique rtf files on the "c" drive. Obviously you will...

I need to distribute a weekly report via e-mail to a list of users. The report has some fairly complex formatting which tends to get lost when I export to excel for onward e-mailing. Is there any way I can e-mail the report direct from Access (either 97 or 2000) ?? Your help is much appreciated.