Fields from 3 tables in one field

[accessgebruiker]

Hi everyone..

I have a problem and I don't know if its possible to solve this. Mabey someone can help me.

This is the problem

I have three tables:

computer
monitor
printer

In every table there is a field: "number".

What I want to do is this:
I want to put the fields "number" from the three tables in just one field in a query, is that possible..

As you know it won't work with this:

Select MSE
from computer and monitor and........;

Thank you in advance

William

 

[KenReay]

Hi

Presumably there is some common field in your three tables to allow you to make a join?

But to get the three fields concatenated as one, make a calcualted field:

SELECT All3:Computer.MSE & Monitor.MSE & printer.MSE FROM Computer .... etc with your join and WHERE clause

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use

 

[accessgebruiker]

Thanks for your information

I'm sorry but that didn't work out.. I think I do things wrong , couse I'm nog very good in sql. But let's make it more simple.

I make a query with three fields. no1, no2 and no3

how do I put these together in just one field.


William

I think this is a very stupid question... but I'm a little newbee in SQL... And in Access they use Jet-SQL..

 

[KenReay]

Hi

Sorry I jumbled it a bit, should have been:

SELECT Computer.MSE & Monitor.MSE & printer.MSE As All3 FROM Computer .... etc with your join and WHERE clause

Regards



Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use

 

[accessgebruiker]

Yeah thanks a lot.....
It do work... but ehmmm I think you're misunderstanding my question...

What I'm getting now is bv:

computer monitor query but what I want is:

5 11 511 5
10 12 1012 10
11
12

I hope this will make things clear..

But thanks...anyway

William