input data against and Query

[bewsh1987]

Hi All



I need your help

I have 3 tables. one for daily task , promotion task and range change task and another table that is a task creator , from all this I have a query (shown below with a lot of data removed.

what I would like if possible is to have a new column needs to be against the query(Wont work against the tables) that has an true or false (Complete/Not complete) answer

I really hope this makes sense if not please ask

Thank you

Task Description	Task Name	Start Date	Task Type	Comments	Task date	Task day
Run Promo Rapid	Period 2	21-Apr-15	Promotion	3 Week Promotion	28-Apr-15	Tuesday
Run Promo Rapid	Period 2	21-Apr-15	Promotion	3 Week Promotion	26-Apr-15	Sunday
Run Promo Rapid	Period 2	21-Apr-15	Promotion	3 Week Promotion	23-Apr-15	Thursday
Delete PSD Policy	Period 2	21-Apr-15	Promotion	3 Week Promotion	26-May-15	Tuesday
Confirmed Ship Report	Period 3	12-May-15	Promotion	3 Week Promotion	05-May-15	Tuesday
LAUNCH - Monitor +Key late Lines	Period 3	12-May-15	Promotion	3 Week Promotion	12-May-15	Tuesday
Run Promo Rapid	Period 3	12-May-15	Promotion	3 Week Promotion	14-May-15	Thursday
Delete PSD Policy	Period 3	12-May-15	Promotion	3 Week Promotion	16-Jun-15	Tuesday
Confirmed Ship Report Day 5	Week 26 Range Change	24-Aug-15	Range Change	Range Change	14-Aug-15	Friday
Remove only full dropping lines from the rapids	Week 26 Range Change	24-Aug-15	Range Change	Range Change	16-Jul-15	Thursday
Confirmed Ship Report Day 9	Week 26 Range Change	24-Aug-15	Range Change	Range Change	21-Aug-15	Friday
Confirmed Ship Report Day 3	Week 26 Range Change	24-Aug-15	Range Change	Range Change	12-Aug-15	Wednesday
Confirmed Ship Report	Period 4	02-Jun-15	Promotion	3 Week Promotion	26-May-15	Tuesday
Run Promo Rapid	Period 4	02-Jun-15	Promotion	3 Week Promotion	04-Jun-15	Thursday
Delete PSD Policy	Period 4	02-Jun-15	Promotion	3 Week Promotion	07-Jul-15	Tuesday
Top 10 Issue Lines	Week 7	13-Apr-15	Daily Task	Daily task	14-Apr-15	Tuesday
Cometics Meeting	Week 7	13-Apr-15	Daily Task	Daily task	15-Apr-15	Wednesday
Store And Depo Stocks	Week 7	13-Apr-15	Daily Task	Daily task	15-Apr-15	Wednesday
Wash Clothes(Test)	Week 7	13-Apr-15	Daily Task	Daily task	19-Apr-15	Sunday
Update PSD's	Week 7	13-Apr-15	Daily Task	Daily task	17-Apr-15	Friday

[ranman256]

what do you consider complete?

iif([Task Type] = 'Done', "COMPLETE","NOT complete") as Status

[bewsh1987]

I would like this to be an input method as I have nothing to formulate against

The data will never get removed so there is no chance of the data being unstable

there must be a workaround some code that will copy the data and put into a table then I can go from there

[orange]

WHAT are you trying to do in plain English? What is the requirement --no Access, no jargon?

Your post indicates HOW you have done something, and that isn't working. But we need to know WHAT before deciding HOW (or options for HOW).

[bewsh1987]

I have data in a query I want a Colum in the query that I can edit/input

[orange]

??That doesn't help

Can you expand upon your original?

I have 3 tables. one for daily task , promotion task and range change task and another table that is a task creator

What do these represent? How did you choose 3 tables? What do the tasks mean? What business are you talking about?

You use Forms for data entry/edit with appropriate validation routines.

[bewsh1987]

Table 1 Set daily task - May change not likely 13 tasks
Table 2 Set promo task - will never change 37 tasks
Table 3 Set range change tasks - will never change 30 tasks

Table 4 [Promotion Type] = task input one line will get all the data from one table all tables have a relationship of [Task type]

ID	Task Type	Task Name	Start Date	End Date	Comments
1	Promotion	Period 2	21/04/2015	11/05/2015	3 Week Promotion
2	Promotion	Period 3	12/05/2015	01/06/2015	3 Week Promotion
5	Range Change	Week 26 Range Change	24/08/2015		Range Change
6	Promotion	Period 4	02/06/2015	22/06/2015	3 Week Promotion
8	Daily Task	Week 7	13/04/2015		Daily task

all the Above gives me a query that look like the example in the first Thread

does this make sense so far or am I confusing the matter even more