Re: How to continuously append live table to table?

LiDongning@xxxxxxxxx wrote:
The proper way would be ONE table and then use queries. One for the
current month and one for the year to date data.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Thanks for the reply, and the question is how to create this YTD
data. It has to be updated every month by adding up the current month
tables to the YTD table.

Not if you have it all in one table. You just have a totals query that
looks at all records for the current year by having appropriate criteria
applied.

Any time you have processes that involve copying data from one table into
other tables that is a big warning flag that your design is incorrect.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages