Forum Discussion
My database has one row per week
The query editor has an option that will "un povit" your week columns.
1) open the table in the query editor
2) select all 52 week columns
3) select unpovit only selected columns from unpovit options
That will solve your first problem.
then select the column with blank values and use the remove empty optionthat should let you get rid of the "empty" values for the weeks when a consultant changed clients
I learn something every time I answer a question
Solution SageGlad to help.
I think you are saying you have 4 tables.
To append your 2018 data to your 2019 data you will have to append only the NON canclulated rows. If you append the non calculated rows from 2018 to 2019, then the calculated rows in your 2019 table should do the same calculations for the rows from the 2018 table.
You can then add a year column to your 2 database week tables and append 2018 to 2019.
Even if you have to remove all your calculated fields to do the append, and then recreate them, it will be much better to combine the data with the year in a year column than to have to set up a new table for every year.
You will find that after you have a few years data you can also do interesting reports that compare year to year statistics.
Thanks a lot! But I have a little doubt: Can I append only NON calculated row? In fact, doesn't forget that in my table I have only week1, week2 etc. So there is exactly the same in 2018 and 2019, I have no date in my table juste the number of the week so if I merge all these things, I will be lost to know which is 2018 and which is 2019, no? Thanks!
- kentyler
Sometimes these things get hard to explain in messages. Send me an email at [email protected] and I'll send you a link to a zoom screen share and we can talk through it.