Adding to Reports...

[Guest]

I was wondering if anyone knew how to have access add a record to a report
only if it reaches a certain event. I am making a database to track
inventory, and the client wants to have a report generated when an inventory
amount reaches a certain amount. Any thoughts anyone?

 

[JohnFol]

Is the inventory amount calculated dynamically in the report?

 

[Guest]

No, I am having it brought in from a query.

Is the inventory amount calculated dynamically in the report?

 

[Guest]

I got it working, I just needed to use an If statement in the VB Code to get
it to hide the ones I don't want.