Here is my problem:
I am making a lunch program for my school. In one table there is the list of Room Number of each classroom and in the second there is a master list of selections. In the selection stable there are 3 fields: Name, Item, Room.
I need a macro in Access that will create and print reports for each rooms selections. It should go down the list of rooms in the room list, and for each number, it should go into the Selection table and pick out the name, item and room, where the selection.room equals roomlist.room. Then it should print a report for each of those queries. After they are all printed it should then delete all the reports and queries and clear the selections table for the next days use (If possible, i need that clearing to take place at a certain time) thanks a lot
YM
I am making a lunch program for my school. In one table there is the list of Room Number of each classroom and in the second there is a master list of selections. In the selection stable there are 3 fields: Name, Item, Room.
I need a macro in Access that will create and print reports for each rooms selections. It should go down the list of rooms in the room list, and for each number, it should go into the Selection table and pick out the name, item and room, where the selection.room equals roomlist.room. Then it should print a report for each of those queries. After they are all printed it should then delete all the reports and queries and clear the selections table for the next days use (If possible, i need that clearing to take place at a certain time) thanks a lot
YM