musicloverlch
2022-05-03 18:08:06 UTC
I might not explain this correctly, but I want to see if you have any solutions to my problem.
I would like to create a table that had the following fields
ID(autonumber)
TaskSection (string)
TaskName (String)
CompleteDate (date)
Then the table would have fields like
Task Section TaskName CompleteDate
Census Email Sent 1/1/2022
Census Census Received 1/5/2022
Census Financials Received 1/7/2022
The goal is for the user to be able to add however many tasks they want without me needing to be involved.
My problem is that I would then need to make a view where they could see all the tasks horizontally. The tasks might change so I can't put a fixed list in the crosstab query.
I really want to do this because I'm sick of having to add fields every time they want to track some new date, but I can't figure out how to overcome the crosstab problem.
Thoughts? TIA
Laura
I would like to create a table that had the following fields
ID(autonumber)
TaskSection (string)
TaskName (String)
CompleteDate (date)
Then the table would have fields like
Task Section TaskName CompleteDate
Census Email Sent 1/1/2022
Census Census Received 1/5/2022
Census Financials Received 1/7/2022
The goal is for the user to be able to add however many tasks they want without me needing to be involved.
My problem is that I would then need to make a view where they could see all the tasks horizontally. The tasks might change so I can't put a fixed list in the crosstab query.
I really want to do this because I'm sick of having to add fields every time they want to track some new date, but I can't figure out how to overcome the crosstab problem.
Thoughts? TIA
Laura