Generate new record

[badboytim]

I am working a job where I need to generate a new line item in a report and
flag a new date requirement for training. The boss wants to see a new line
item in the report for each document revision, and ants there to be a report
that flags employees that need new training based on the new document
revision. Also the boss hsn't gone in for paying for any VBA training, so I
would like a non-programming answer if possible. Thanks.

 

[Jeff Boyce]

Reports in Access (this is a Microsoft Access newsgroup) are based on data.
If your data structure has a way to record "a new line item" and/or a
"document revision", you can build a report that shows that.

If you have a list of required training, a list of employees, and a list of
employee trainings, you can build a query that shows which trainings are not
yet completed by which employees.

None of this would require VBA.

All of this would require some familiarity with Access.

Regards

Jeff Boyce
Microsoft Office/Access MVP