Recent content by scottm

Regarding the Null, that part seems to work perfectly as it want it to be a blank field if no data exists, Is there a better way I should be doing this? Sorry, I am a bit of a Beginner at access, How would I do the join or select in the report for each value type? The Paper Values ("A4...

Hello, I am creating a report that will group together certain values to return a total value The issue is, when I add more items to this list, it will return #error the code in question is: =Sum(IIf([disb] In ("A4 B&W","1","A4 B&W Duplex","Letter B&W Duplex","Letter B&W","Duplex A4 B&W","A5...