How to create a report that includes all data entered since the last print?

[bozrdang]

Thanks to some help from some of you, I'm making some good progress on my db for work. Now, I have something I want to impliment and I'm not sure where to begin.

We are a plastic manufacturing plant and I'm creating a db to enter orders, deduct daily production quantities, and produce a packing slip. My problem is with the packing slip. Basically, what I want to do is allow a foreman to enter their shift's production numbers for each part produced and allow them to print a packing slip at the end of their shift. Obviously, each packing slip would begin empty for each shift. I know I could use a select query to sort production entries by date and shift, but I'd rather it record all entries made until a report (packing slip) has been printed and then start a new packing slip (empty report) that records all entries made since the last one was printed and so on.

I hope I made that clear.

 

[Elana]

Here's an idea:

Create a table to hold information re: the date/time a report is printed. Each time the report is printed, use code to programatically add a record to this table.

Then have the report only print those records posted after the last date/time entered in the table mentioned above.

Hope this is what you were looking for.

E

 

[bozrdang]

I don't understand how I would implement that. Sorry, but I'm still a bit new to Access.

 

[Elana]

Take a look at this MS Knowledge Base article on maintaining a print log for reports (article no. 154894)

http://support.microsoft.com/default.aspx?scid=kb;en-us;154894

HTH

 

[bozrdang]

Thanks! I'll check that out!!