Recent content by dearlandlord88

Have now solved this. In case anyone else ever comes across this with a similar problem, the issue was that the query on which the master report was based for some reason contained the table on which the subreport was also based. Even though no fields from this table were selected in the...

Hi Rain, Thanks for this - it's definitely a report, but with a subform within it. I don't think it's a problem with page division, the issue is that wherever there are multiple records in the subform, Access will show the master report a corresponding number of times. I want it to only show...

[SOLVED] Report Displaying Multiple Duplicate Records due to Subform Hello all, I currently have a report which contains a subform. The master/child fields used to link them are called 'StudentID'. In the table on which the subform is based, it is possible for multiple records to be...

Many thanks, I'll explore both options and see where I get.

Hello all. Hoping someone may be able to help with an error I keep getting with the syntax of an update query I'm putting together. I'm sure it's an embarrassingly basic mistake I'm making, but I'm fairly new to Access and can't seem to find a solution. Have searched this and other forums for...