adding a column

[smason]

I have a tablequiery which i run which shows KPI's for the week, it looks
like this

01/01/2005
a
b
c

I want to automaticaly add the next days figures via a quiery to the table
when i run the quiery so it add a column like this

01/01/2005 02/01/2005
a c
b b
c a
and so on any ideas?

 

[Brian]

Try to avoid adding fields (columns) in order to add more data. Add records
instead Try something like this:

KPIDate KPI
01/01/2005 a
01/01/2005 b
01/01/2005 c
01/02/2005 c
01/02/2005 d
etc.

Then, when you want to add another line, add the date & the KPI element.
Then, you can present it any way you like in the reports you create.

 

[smason]

Thanks for the info

Try to avoid adding fields (columns) in order to add more data. Add records
instead Try something like this:

KPIDate KPI
01/01/2005 a
01/01/2005 b
01/01/2005 c
01/02/2005 c
01/02/2005 d
etc.

Then, when you want to add another line, add the date & the KPI element.
Then, you can present it any way you like in the reports you create.