Which is better Performance - Make Table Query or Delete then Append

[mordja]

Hi,

Im just wondering which will offer better performance out of making a table each time I run a query, or deleting data from the existing table and appending it.

THanks

Mordja

 

[dhookom]

This might depend on quite a number of factors including indexes and relationships between tables. You might want to test this for your situation and then report back.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]