Search results

Hi Guys, I have a spread sheet that I use to manage some projects (Programme) What I have is the project name's in B5, B6.....B117 In C5 I have a start Date of the project D5 Calculates the if it is over or under time. I only enter dates in the (red Accent 2 80%) what i call a pinkish colour...

Sorry my misunderstanding Insert a group on the count and then create three formulas: //{@reset} for the group header: whileprintingrecords; stringvar x; if not inrepeatedgroupheader then x := ""; //{@accum} to be placed in the detail section: whileprintingrecords; stringvar x := x +...

If you publish the sql statements separetly does it take the same amount of time in Infoview?

The easiest way is to right click on the field and go to Format Field Then clcik on the Font Tab under the Color and then go to the formula to the right X2 and format there. But if you are highlighting the font the blanks will never colour as nothing is there. To get this to work follow the...

Try creating a formula that looks a bit like this table.contactnumber+","+table.count

Not sure what you are trying to do here. Are you wanting to place many images in a report but only display based on the selection of the prompt?

Thanks, Not that I know how to do what you have suggested but thanks for the reply.

Hi, If they unique identifier you have used are in both, try using a left or right outer join. Send a screen shoot of what it is you have and what the data extract is with the rpt file and I will see if I can help you further. Cheers

Hi Guys, I am new at this and am not one that really knows MS Access. I have an issue where we have recently upgraded our MS Office versions from Office 2000 to Office 2007. We have a query that seems to be linked to many other queries and takes a while (many minutes) to run. We have not...