Recent content by sqw

Sorry for the trouble but still having a few issues is there anyway of saying if details is supressed then show group header1 Thanks for all the help

HI Thanks for all the usefull replys I have tried these and they work in a fashion but I get "no calls this month" repeated for each call that was not in the month for each customer. I have tried to supress if duplicated but this still does not work it shows more that one text for each customer...

How much would you charge to sort this issue out

Hi Thanks for the quick feedback did not think anyone would bother replying on a sunday night! Unfortunatly due to the layout of our db I have had to link in lots of tables with numerous link most are inner joins. I have added the sql below as you can there are lots of links hope this helps...

Hello I am really desperate for some help on a report I have been working on for ages. It is a report that goes to our customers stating their name, address in group header 1a this information is to always be visable on the report. Then in group header 1b is a list of all support calls that the...

Please can someone help I have a report and want to include a parameter field. I want to be able to type in the name of a customer like "Acme*" and for the parameter to get the result "Acme Ltd Company" or whatever the other part of the company name is. Thanks

Thanks for this response I will try this and let you know how I get on.

I have a report and I have spilt the details into two so I have DetailsA and DetailsB. I want to suppress DetailsB and show DetailsA if a date in DA is within the period of the last full month. If it is not in that period then I want to show DetailsB and supress DetailsA. I have tried the...

Thank it is sorted now like stated above it was a problem with a printer that was intalled but not connected so when word opened it spent a while looking for it. Removing this printer sorted it out. Thanks for all the help

Hi Everyone I have a bit of a strange problem. If I open Word 2003 on its own it opens fine very quickly. If I do file - open and select a document from the desktop it opens quick. If I close Word and double click on a document on the desktop it takes a good 30 seconds to open. I have done a...

I have tried that and it works great Thanks alot

Thanks for the quick respone, I have tried the following formula whileprintingrecords; Sum ({Command.double05}, {Command.name(1)}) but this still comes up with the same total. Do you have any more ideas please? Thanks

I have a report that runs and I have a column called hours. There are duplicated hours in this and I have selected suppress if duplicated. But the total for this column still includes the suppressed data. Is there any way to suppress if duplicated and for it to not be included in the totals if I...

Excellent thanks I will try this

In the group header I have address and name of the company and I want this to show all the time. The next group header has all the calls that that company has logged in. What I want to do is always show the first group header now matter what. Then What I want to do is filter all the calls and...