I am creating a report for pupils, grouped by school then collection time. I have managed to count the number of pupils being collected using the formula...

Hi everyone, I have two tables Table_POR_Final and Table_Workdays On Table_POR_Final there are the following...

Dear All I have an MS Access database which i would like to upload it so that the forummate can assist me in figuring out the problem I am having. Please...

Is it possible to set the fill property of a check box to no fill (i.e., transparent)?

I have just converted a database from Access 2003 to Access 2007, and for some reason the formatting of some of the reports has gone haywire. The height for...

Does anyone know how to get the program to display the & (ampersand) character in a title, header or label? Normally this character is used in code to...

I have three tables (parent/guardian, children, otheradults). that are all related with left joins (i.e. Include ALL records from 'Parent/Guardian' and only...

Hi, Is there a way to change report name to be like OrderID_FirstName_LastName I need it to be like that already in report preview because my pdfprinter is...

I have three tables (Contacts, Children, Other Adults). They are all related by the ContactID. Not all contacts have children, some have more than one adult...

I have a report called SWO R on this report I have a subreport called BILLABLE LABOUR R. I would like to create an if statement that returns a zero billable...

I have a database with a few relationships in it. The patient and their dependants are in two separate tables and a rate of Fee is in another. I have a...

I have a report that is a summary. I have a group footer on field WCNo. I want to group within that group. Is that possible? Here is an example of...

I’m using Access via Office XP. I need to generate a report that can have three different signatures on it. Each signature is in a .jpg file. Based upon...

I have a report based on a query. How can I group records by the last time (max date) a check box is true? -- Thanks for your help! Walter

Hi All, I'm Running Microsoft Access 2007. In reports, when I sort my report by date - access does not sort it correctly (i.e. it sorts dates in this order...

Hello, I have this expression in a subreport textbox "Total Personnel with Fringe": =(+)*1.24 The two totals boxes are above this. The report is grouped by...

I made a report 6 months ago. I want to add a field to the report from the table that the report is pulling info from. The field is totaling 2 fields from...

I want to print the info from a sub report and have the info deleted at the same time

I have a report that is using a subreport, which I would like to then leverage through e-mail merge. The Report has customer information in the top,...