pulling info from a form

  • Thread starter Thread starter marc
  • Start date Start date
M

marc

I am trying to pull some information from a form and place
it on to a form. First let me give a quick background of
what I have.

I have 14 tasks on a main form. Each task breaks down
into 5 other subtasks in a subform. I have a field with
each subtask called status.

I am trying to get a weekly report to autmatically check
the status field of each sub task for the word current.
Lets say task 1 subtask b shows it. I want the report to
show that tasks weekly status and title.

Is this possible to do?
Please help
Marc
 
I would create a query doing just the search you described
and than base the report on that query.
Hope this helps.
Fons
 
let me ask you this.

If i have a task 1 subtask b whos statsus says current.
How do I get the weekly status of that task to show up in
its own field along with the current ECD. How would you
recommend to deal with more than one task that says
current.
 
Can you give me some more information about the table(s)
structure. I assume it is one table (Main) for the main
tasks, with 14 records.
One table (SubMain) with 5 subtasks for each of the 14
main tasks (5*14 = 70 records)
There is a one to may relationship betweem table Main and
SubMain.
The Query could be based on the two related tables with a
filter for Like "Current*" in the appropriate field.
Let me know where I misunderstand.
Hope this helps.
Fons
 
you are correct on the tables. One for the main and one
for each sub task. The main tasks are on a sub form that
goes into the main input form. The subtasks are a 1 to
many relation to a tbl called tblAction Item List. The 1
against the tblAction item list. I have subtask tables
for each task and those are 1 to many relations as well.
Again the 1 is against the tblaction item list.

The tasks on the main form have the following fields with
each task:
status
manager
task name
original start
current start
original finish
current finish
previous
end

the only thing that is different from the above for the
subtasks is the following additional fields to the ones
above:
weekly status
monthly status
history status

What you have would work if I only had one task at a time
current. What if I am have 2 tasks that are current at
the same time. How do I take care of that?
 
I tried to create a sample mdb based on the information.
I am a bit confused with the duplication of the data
fields. Is it possible for you to send me a sample mdb
file. If you do you should change the extension first
(you could change the .mdb to .txt) otherwise most virus
scanners will reject the attached file.
Let me know. (the email address is above)
Fons
 
Back
Top