Advice on Append Append query (1 Viewer)

[Andhurley710]

I hope this is simple enough but I am self taught on Access so I dont know everything lol...

I have a table for Invoices, very simple and a few fields

I can append the paid invoices to an Accounting Transaction table, when doing so there is a field in the Transaction table that should say income for all invoices archived.

Is there any way of doing this alongside the append query in a macro with another query? Possibly an update query so the user doesn't have to go through each record and select income for the invoices?

Thanks In Advance

Andrea

 

[Minty]

You could run a single update query to do this assuming the invoice number is in both tables after the append has run.

Create a select query that joins the transaction and invoice tables joined by invoice number where the archive field is null

If that gets you to what you want to see, then change it to an update query and set the archive field accordingly.

 

[Micron]

I can append the paid invoices to an Accounting Transaction table,

That sounds like duplication of data to me. Why would you not simply 'mark' the invoice table record as paid via a date value in a field named something like PaidDate?