copy information from table to anothor

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi every one

i have one table "invoice register" in which i will enter any invoice i
receive "taking to consideration that i may reject some of them after
checking" but any way i should keep record for any invoice i receive will
some details(inv no , period from,to , amount)

but i have another table "expense reports" in which i enter only the
approved invoices. what i need is , to pull those fields entered in the
"invoice register" to my form "expense reports " = my table " expense
reports"

is this possible.
 
It's possible (using an INSERT INTO query), but it's probably not a good
idea, since that would result in duplicate data.

Why don't you simply put an Approved flag on your invoice register table?
That way, you can create an ApprovedInvoices query that only returns those
where the Approved flag is set to True. Use the query wherever you would
otherwise have used the table.
 
Back
Top