Create a querry to select certain records from a Acess Table

10 pts.
Tags:
Microsoft Access
I am creating an Access database that contains a lists of tasks. MY QUESTION IS is there a way to create a query to pull a subset of those tasks to be included in a job? As new jobs are created, I need a way to include a new subset of tasks in a report without have to input all of the tasks needed all over again.  To further illustrate my question:

Job # 1 includes tasks 1, 2, 4, 9 & 10

Job # 2 includes tasks 1, 3, 4, 10 & 11

I need to create a report for each new job comes along that lists each task to be included for that job.  It can be done by having a separate field in the task table for each job and set the value for yes or no, but there must be an easier way of doing this. 



Software/Hardware used:
MS-Access 2007
ASKED: May 10, 2010  8:31 PM
UPDATED: May 10, 2010  8:51 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

You should create one table for the JOBS, one for the TASKS and one for the JOB-TASK relations.

Here’s a simplified example:

<pre>JOBS

job_no job_name
1 JOB ONE
2 JOB TWO

TASKS

task_no task_name
1 TASK ONE
2 TASK TWO
3 TASK THREE

JOB_TASK

job_no task_no
1 1
1 2
1 4
1 9
1 10
2 1
2 3
2 4
2 10
2 11</pre>

-CarlosDL

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following