move row to a report when status changes.

[Sbarnes814]

Hello, I am very new in Access and need help on this. This would be an ongoing report and When the STATUS changes to "COMPLETE", and the row is filled, I would like an option to move ALL COMPLETE rows from the report to another report for records. Please let me know your thoughts on this and let me know if this can be done. The status line would be NOT AVAILABLE, AVAILABLE, DELIVERED, EMPTY, OR COMPLETE. thanks in advance. It is not letting me upload a copy of my report, and i'm not sure how to reduce the size of it?

[RuralGuy]

As for size of upload, Compact and Repair the db and then zip it up to upload.

[John_G]

You don't "move" data from one report to another. Reports don't contain data, they only list and/or summarize it. The data a report shows is determined by the data it get as its record source (a table or a query), and determine what records are in the record source by applying the required filters to it.

So, I assume you have a table which has a status field in it, which contains one of the values NOT AVAILABLE, AVAILABLE, DELIVERED, EMPTY, OR COMPLETE.

The report for completed activites (or whatever it is) would show only rows where "Status = 'Complete'". When you change a status value, it will automatically be listed in relevant report. Of course, you do have to re-run the reports after making status changes.

[Sbarnes814]

Thank you RuralGuy, appreciate it.

[Sbarnes814]

John_G, Thank you for the tips. So much to learn coming from using mainly only Excel. Would I create another report named "COMPLETE"?

[RuralGuy]

You're very welcome.

[John_G]

Would I create another report named "COMPLETE"?

You could, especially if the layout of that report differed form the others. However, you still have to ensure that the new report only uses the records with status = "Complete". This is most easily done with the WHERE clause in the OpenReport command, something like this:

docmd.OpenReport "Complete",,,"Status = 'Complete' "

[Sbarnes814]

Hello, I am very new in Access and need help on this. This would be an ongoing report and When the STATUS changes to "COMPLETE", and the row is filled, I would like an option to move ALL COMPLETE rows from the report to another report for records. Please let me know your thoughts on this and let me know if this can be done. The status line would be NOT AVAILABLE, AVAILABLE, DELIVERED, EMPTY, OR COMPLETE. thanks in advance. It is not letting me upload a copy of my report, and i'm not sure how to reduce the size of it?

Here is the file I am working with.