Question about copying a data with a condition.

foody

Registered User.
Local time
Today, 05:35
Joined
Sep 21, 2005
Messages
36
I have an invoice set in a lovely form using Microsoft Access. Each of the invoice there is an option on the top called Paid, ones I check the paid it will stamp it as paid, how do I make it such as, it will copy the paid ONLY record into a summary cheat, which is a report? It have to be copied into a table of course, but I want to copy from the entire invoice which include

Invoice numer, data, name, addres,s blah blah, all I want to be copied is just the number, the name and the total balance and I want that information only to be copied into the table by clicking the Paid check on the form. My other question, how do I delete THAT PERTICULAR record that was copied from the invoice into the new table? Thanks in advance.

Please if possible? Could you explain it as easy as possible with me with as much as examples and easy to read? I am a little slow, thanks. I thank you all again for your help in advance.
 

Users who are viewing this thread

Back
Top Bottom