Simple prgnostic query, extending time trend in table

[maati1980]

Hi all,
I've been out of access for about 10 years and some of the solutions slipped my mind. The question is how to transform table with time series to extend time horizon. I have data for 12 months and I would like to see 24 months. I see the data as:



and I would like to get extended timeline like this:


Thanks in advance for any clues.
maati

[Micron]

I hope your data doesn't really look like that and that those are not your real field names.

Notwithstanding the fact that you shouldn't be continually working directly on tables, the short answer is that you can grab Excel rows if that's what you have, and Paste Append (Access ribbon) into a table. I do that if testing and need quick data, but one should be modifying or appending data via forms or queries in a finished db.

[maati1980]

:-)
The data is simplified to explain the problem easier. I have database with salaries and I would like to prepare simple prognosis of these based on last 12 months history. I would use a lot of parameters which will modify Values for future months. I didn't want to describe all complexities here as I think I can handle it myself.

[Bulzie]

Not really understanding your set up. Is that tables at the top or queries based on tables? For date increments, you could use DateAdd function to add a month at a time.