Append query problem

  • Thread starter BabyATX13 via AccessMonster.com
  • Start date

B

BabyATX13 via AccessMonster.com

I have a database that is just huge, and at some point in time the company
will have to archive the data in the tables, for the most part I can do this,
the problem is with my linked tables. I don’t know how to archive them all at
once.

Example

Invoice table:
InvoiceNo Auto Number Primary Key
DateFrom Date/Time
DateTo Date/Time
CompanyName Number

15 Blling Tables:
BillingID Auto Number Primary Key
InvoiceNo Number
And some other irrelevant stuff, all different from table to table, depending
on the billing type.

All 15 Billing tables are linked to the one Invoice table by InvoiceNo. My
problem is, I am archiving the invoice table by date and I want the linked
Billing tables’ information to go with the invoice number for those dates
that are archived. I now realize, had I thought of it years in advance, that
a date field in the billing tables would have been helpful, but it is too
late to fix now, as there are thousands of records in them now.

Any help on this matter would be greatly appreciated.
Thank you,
K Board
 
Ad

Advertisements

G

Guest

Try linking BillingID to DateTo as BillingID is related to InvoiceNo in
Billing table and InvoiceNo has a DateTo in Invoice table.
 
Ad

Advertisements

B

BabyATX13 via AccessMonster.com

Actually InvoiceNo in Invoice table is related to InvoiceNo in Billing table
One invoice will have many billing details.

S said:
Try linking BillingID to DateTo as BillingID is related to InvoiceNo in
Billing table and InvoiceNo has a DateTo in Invoice table.

What will that do for me?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top