Recent content by Angel-888

Thanks Pat, however instead of a blank cell in my report I have "#Error" appearing in my text box. Is there a way to add to the query?? or am I missing something else. I have even tried adding the table name infront such as: =Sum(Nz([Tbl_ContractAgreementDetails.S1_MaxProfSupportAmt],0) +...

Sorry I forgot to mention that some of the fields would blank. How is this shown if need special treatment. Thanks

Hi, I'm using Access 2010 and creating a report that is summing 16 fields but the wizard says I have too many fields selected. I had tried creating the report from scratch adding a sum field in the group footer but the field appears blank. Below is what I am adding together all from one...

Great thanks. It worked when I added to the control only ie the date field. When I tried to make it all a sentence with the additional text (="The Program... " & [datefield]) it still reverted back to the short date context with the full stop at the end. I have just left the text as a label...

Hi, I have a report where I added text then a date field based on a Table. In the table I have specified the "Co_ContractEndDate" for input mask as dd/mm/yyyy, however the format to display as dd mmmm yyyy. This works in the Form and in the report as it's own control text box, however when I...

Thanks for your help. The report changed and no longer needed the IIF statement. I have kept a copy of your info for future use will let you know how I go then. Thanks again!

Great thanks for the reply, but as mentioned I'm quite new. Where do I put the statement in the report or query and how do I set the conditional formating? Sorry to be a pain but I have not done this complexity before, it will save me creating another report and query for just one label...

Hi I am quite new to access 2007 but trying to create an IIF statement in a report but don't know where to start. My report has lots of 'Label' fields with standard text based on a query for the fields components. I want one of my labels to only appear on the report for print IF a record...

Great thanks I forgot about the control source. All is working as it should, I've changed the text a little so I don't have the double quotes in the string. Thanks again :)

Hi Paul, I've attached a simple version of the database I am creating with just the Rental Agreement Report. As you will see in the first two paragraphs I have some fields I want to merge. Perhaps I have the spacings all wrong? The Access database version states "Access 2007-2010" so not...

Thanks for helping, The exact format I am entering is: "This Service Agreement has been negotiated by "&[CompanyName]&" to enable provision of a "&[ServiceType]&" service." Yet the response when I go to print is: This Service Agreement has been negotiated by [CompanyName] to enable...

Hi, I am building a report in Access 2007, similar to a mail merge word doc where I have a text then want to add a field in the middle of it, such as: This Service Agreement has been negotiated by [CompanyName] to enable provision of a [ServiceType] service. I have added "&" with the field...