Report Help

[majoh60]

I have a report based on a query (screenshots attached) that summarizes an actual amount based on Transaction Codes in one column and the second column formats that amount in the way it needs to be reported on our government report. Now I need to find a way to query the FormatAmt by Transaction Code sum to give me only the amounts that are greater than a certain amount and to exclude the rest. This information could go on a separate report or if there is another way, I can try that. I hope I am explaining this in a way that makes sense.

[June7]

Did you try filter criteria under the FormatAmt field?

Or use WHERE argument of DoCmd.OpenReport and reference an input box on form

DoCmd.OpenReport "TranCodeReport", , , "FormatAmt=>" & Me.tbxAmount