Can somebody help me with this query?

[Wim Verschaeve]

I have a database with 2 tables (one with names of 3 people and one with the
things that they will do every hour). Now i want to make a query with these
2 tables and i want to get this result:



Name 14 15 16
Jantje javascript router beveiling
Anneke router javascript beveiling



The things in blue are the names from one table and the things in red are
the things that they will do every hour.

Is there anyone who can help me with this? If you want you can get the
database by mail.



Wim

verschaeve.wim@(nothing.here)pandora.be

 

[Guest]

Hi Wim,

The result you are showing looks like it might be a crosstab query type
result. Try the tutorial I have available here:

Crosstab Queries
http://www.access.qbuilt.com/html/crosstab_queries.html

Note that crosstab queries are read only. You cannot add or edit existing
data to a crosstab query result.

The things in blue are the names from one table and the things in red...

Sorry, but no colors came through for me.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I have a database with 2 tables (one with names of 3 people and one with the
things that they will do every hour). Now i want to make a query with these
2 tables and i want to get this result:



Name 14 15 16
Jantje javascript router beveiling
Anneke router javascript beveiling



The things in blue are the names from one table and the things in red are
the things that they will do every hour.

Is there anyone who can help me with this? If you want you can get the
database by mail.



Wim

verschaeve.wim@(nothing.here)pandora.be