By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,833 Members | 2,067 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,833 IT Pros & Developers. It's quick & easy.

How to continuously append two tables?

P: n/a
At month end, there will be a month-to-date table that should be
appended into the Year-to-date one. The MTD table is a lump-sum one,
no way to enter into the YTD one entry by one entry. I can append Feb
MTD to Jan MTD and make it a YTD table, just don't know how to do it
continuously. For example, March, the only thing I can think of is to
delete the Feb MTD, replace it with March MTD, and then append to the
YTD. but this will involve name changing and other stuff. do you
know a better way to design this? thanks.

Sep 25 '07 #1
Share this Question
Share on Google+
8 Replies


P: n/a
If your transactions have dates, use a query for MTD and YTD instead of
tables.
If no dates add them.

<Do********@gmail.comwrote in message
news:11**********************@o80g2000hse.googlegr oups.com...
At month end, there will be a month-to-date table that should be
appended into the Year-to-date one. The MTD table is a lump-sum one,
no way to enter into the YTD one entry by one entry. I can append Feb
MTD to Jan MTD and make it a YTD table, just don't know how to do it
continuously. For example, March, the only thing I can think of is to
delete the Feb MTD, replace it with March MTD, and then append to the
YTD. but this will involve name changing and other stuff. do you
know a better way to design this? thanks.

Sep 25 '07 #2

P: n/a
The problem is I only need YTD, and the previous YTD does not contain
the current MTD.
They all have dates.
On Sep 25, 10:38 am, "paii, Ron" <n...@no.comwrote:
If your transactions have dates, use a query for MTD and YTD instead of
tables.
If no dates add them.

<Dongnin...@gmail.comwrote in message

news:11**********************@o80g2000hse.googlegr oups.com...
Sep 25 '07 #3

P: n/a
MTD query would use the dates to select transactions entered in the current
month.YTD would need to do the same for current year, unless you plan to
delete the transactions for the previous year.

<Do********@gmail.comwrote in message
news:11**********************@r29g2000hsg.googlegr oups.com...
The problem is I only need YTD, and the previous YTD does not contain
the current MTD.
They all have dates.
On Sep 25, 10:38 am, "paii, Ron" <n...@no.comwrote:
If your transactions have dates, use a query for MTD and YTD instead of
tables.
If no dates add them.

<Dongnin...@gmail.comwrote in message

news:11**********************@o80g2000hse.googlegr oups.com...
>

Sep 25 '07 #4

P: n/a
I can create MTD query to select the current month transactions from
my MTD fresh data, but it still does not solve the question of how to
put the current month transactions into the YTD. YTD is the one I
need. Thanks for you reply.

On Sep 25, 11:11 am, "paii, Ron" <n...@no.comwrote:
MTD query would use the dates to select transactions entered in the current
month.YTD would need to do the same for current year, unless you plan to
delete the transactions for the previous year.

<Dongnin...@gmail.comwrote in message

news:11**********************@r29g2000hsg.googlegr oups.com...
The problem is I only need YTD, and the previous YTD does not contain
the current MTD.
They all have dates.


Sep 25 '07 #5

P: n/a
You should not need separate MTD and YTD transaction tables.

<Do********@gmail.comwrote in message
news:11*********************@g4g2000hsf.googlegrou ps.com...
I can create MTD query to select the current month transactions from
my MTD fresh data, but it still does not solve the question of how to
put the current month transactions into the YTD. YTD is the one I
need. Thanks for you reply.

On Sep 25, 11:11 am, "paii, Ron" <n...@no.comwrote:
MTD query would use the dates to select transactions entered in the
current
month.YTD would need to do the same for current year, unless you plan to
delete the transactions for the previous year.

<Dongnin...@gmail.comwrote in message

news:11**********************@r29g2000hsg.googlegr oups.com...
The problem is I only need YTD, and the previous YTD does not contain
the current MTD.
They all have dates.



Sep 25 '07 #6

P: n/a
The tables come seperately and I wanna combine them month by month.

For example, at March month end, I have a March MTD table and I want
to append the March MTD to the YTD table. This is not a problem, but
how about April MTD? I'll have to create another April MTD table and
change my append query, and delete the March MTD. Is there a better
way to tackle this? Thanks.

On Sep 25, 12:13 pm, "paii, Ron" <n...@no.comwrote:
You should not need separate MTD and YTD transaction tables.


Sep 25 '07 #7

P: n/a
The table structure is your problem.

As I understand it you store your transactions in the MTD table with the
month name part of the table name. At end of month you copy to a YTD and
delete the MTD. Then you create a new MTD with the new month name. How do
you maintain forms and reports with the table name changing every month? Or
are you entering data directly into the tables?

I am suggesting you stop creating and deleting MTD table, use the YTD table,
maybe rename it. One table and 2 queries will eliminate the need to change
and use the append query.

<Do********@gmail.comwrote in message
news:11**********************@57g2000hsv.googlegro ups.com...
The tables come seperately and I wanna combine them month by month.

For example, at March month end, I have a March MTD table and I want
to append the March MTD to the YTD table. This is not a problem, but
how about April MTD? I'll have to create another April MTD table and
change my append query, and delete the March MTD. Is there a better
way to tackle this? Thanks.

On Sep 25, 12:13 pm, "paii, Ron" <n...@no.comwrote:
You should not need separate MTD and YTD transaction tables.



Sep 25 '07 #8

P: n/a
Thanks for consistently replying my question.

The data can not be entered into my YTD table and they only come in
once in a month in an excel table. I just tried copy and past the
excel table to my YTD, it worked. now I have only one table to work
from... Thanks a lot.
On Sep 25, 1:20 pm, "paii, Ron" <n...@no.comwrote:
The table structure is your problem.

As I understand it you store your transactions in the MTD table with the
month name part of the table name. At end of month you copy to a YTD and
delete the MTD. Then you create a new MTD with the new month name. How do
you maintain forms and reports with the table name changing every month? Or
are you entering data directly into the tables?

I am suggesting you stop creating and deleting MTD table, use the YTD table,
maybe rename it. One table and 2 queries will eliminate the need to change
and use the append query.
Sep 25 '07 #9

This discussion thread is closed

Replies have been disabled for this discussion.