Query into query

[Mra3134]

Hi everybody,

i need a query in a query for a necessary report in microsoft access. Here is the description:

The first table is named 'Tasks'. It has 5 fields: 'Task ID; Task Name; Due Date; Member; & Description'.
The second table is named 'Daily Report' and has 8 fields: 'Report ID; Date; Member; Task 1; Task 2; Task 3; Task 4; Task 5'.
Now i want a query with this fields from these tables: 'Report ID; Date; Member; Task ID; Task Name; Due Date; Description'. But i cannot create it. Please help me ASAP.

Tnx,


MRA

[ranman256]

why 2 queries? Can 1 work?
use the query designer, bring in the tables you asked.
join tables on like fields.
run query.

[Mra3134]

Actually i need 1 query, but i need 2 tables. one has tasks details and the second details of reports which have 5 task IDs related to 'Tasks' table. did you understand?

[andy49]

Are the tables joined? And why can't you? Too many records? Query won't select data?


Sent from my iPhone using Tapatalk

[Mra3134]

yes task id numbers are FKs. but the select query or simple query doesn't work or maybe i don't know how to use.

[andy49]

Have you used query wizard


Sent from my iPhone using Tapatalk

[Mra3134]

yes but it doesn't work.

[andy49]

Could you give us the tables with some data?


Sent from my iPhone using Tapatalk

[Mra3134]

first table:


reports table:


the query which i need:

[Mra3134]

and this is the relationships:

[andy49]

go into design query SQL mode

this works for me

SELECT tasks.description, tasks.member, tasks.[due date], tasks.[task name], tasks.[task id], reports.date, reports.[report id]
FROM reports, tasks;

I missed your post on joins and didn't have any

[Mra3134]

sorry:

[Mra3134]

and it wants many parameters from me like tasks.duedate

[andy49]

Try it now


Sent from my iPhone using Tapatalk

[andy49]

But some of your fields are badly named. (Spaces are never a good idea task_ID) and date shouldn't be used as its a function leading to confusion later.

I suggest once you have a working query you change the field names and adjust the query accordingly.

It will save masses of grief later on.


Sent from my iPhone using Tapatalk