Adding Reply Archived Topic: It will not be bumped to the top of the forum. Topic Microsoft Access Unexpected Parameter Value Request Membername   Not a member? Sign Up Free (takes 20 seconds) Password   Forgotten your password? Post Font: Verdana Arial Black Georgia Comic Sans Impact   Size: Tiny Normal Big Huge   Color: Default Dark Red Red Orange Brown Green Olive Cyan Blue Dark Blue Indigo Black [ Check Spelling ] [ Post Preview ] [ LiveTags ] FAQ Keyword Search: Post Options Favorites Manager Notify me of new replies to this topic by email Notify me of new replies to this topic by private message Original Post straypussy Posted at 6:54 pm on Mar. 14, 2007 I've been working on this database for a few days now and I keep having a problem with a query that I'm doing. I'm attempting to create a report showing the payment for examiners marking GCSE scripts and my gross pay field doesn't seem to be working. The gross pay is merely the total number of scripts marked multiplied by the fee per script (which varies depending on subject). The problem seems to be that because the total number of scipts is calculated by added the number of scripts each examiner marks at each school. I can't see where I've gone wrong though. Help would be much appreciated.

Replies straypussy Posted at 6:54 pm on Mar. 14, 2007 I've been working on this database for a few days now and I keep having a problem with a query that I'm doing. I'm attempting to create a report showing the payment for examiners marking GCSE scripts and my gross pay field doesn't seem to be working. The gross pay is merely the total number of scripts marked multiplied by the fee per script (which varies depending on subject). The problem seems to be that because the total number of scipts is calculated by added the number of scripts each examiner marks at each school. I can't see where I've gone wrong though. Help would be much appreciated.