Search results

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...

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...

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...

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...